C
Coal Miner
The following formula is supposed to return a count of unique values from
column F if the following 2 criteria are met: 1) If Column C=C16, and 2) If
Column P=True
=SUMPRODUCT(--('Jan Database'!$C$2:$C$55200=C16),--('Jan
Database'!$P$2:$P$55200=TRUE),--(('Jan
Database'!$F$2:$F$55200<>"")/COUNTIF('Jan Database'!$F$2:$F$55200,'Jan
Database'!$F$2:$F$55200&"")))
The formula is not returning the correct value. Also, it takes FOREVER for
this to calculate (I have about 10,000 to 15,000 rows of data). Any ideas to
correct the formula? How about the time to calculate?
As always, thanks in advance!!!
column F if the following 2 criteria are met: 1) If Column C=C16, and 2) If
Column P=True
=SUMPRODUCT(--('Jan Database'!$C$2:$C$55200=C16),--('Jan
Database'!$P$2:$P$55200=TRUE),--(('Jan
Database'!$F$2:$F$55200<>"")/COUNTIF('Jan Database'!$F$2:$F$55200,'Jan
Database'!$F$2:$F$55200&"")))
The formula is not returning the correct value. Also, it takes FOREVER for
this to calculate (I have about 10,000 to 15,000 rows of data). Any ideas to
correct the formula? How about the time to calculate?
As always, thanks in advance!!!