CountIF formula

[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

 

[Anne Troy]

Hi, Rose. Try this:
http://www.officearticles.com/excel/count_using_multiple_criteria_in_microsoft_excel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

 

[ROSE2102]

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

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

 

[Dave Peterson]

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

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