CountIF formula

R

ROSE2102

I need to run a countif formula, with 2 conditions on two different
columns, The first condition is that column D matches cell A1 (text),
the second condition is that column K is greater than 0.

I need it to count the number of rows that meet the given conditions.

Please let me know if you can help
 
R

ROSE2102

No it didn't work, it can back with an #VALUE Error. The formula I a
using is as follows:

=COUNTIF('Interim Funding'!D2:D900,A1)*('Interim Funding'!$K$2:K$90
 
D

Dave Peterson

=sumproduct(--(d1:d99=a1),--(k1:k99>0))

Adjust your range, but don't use the whole column.
 
Top