Doesn't
=COUNTIF(D4:D57=0)
work? If not, is it because of some condition in CO, such as not empty?
If so, how about
=SUMPRODUCT(--(D4:D57=0),--(C4:C57<""))
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"tratliff " wrote in message
...
I have two columns C and D.
I want to count the items in C only if the sales volume in column D are
0.
Here is my formula:
=COUNTIF(C4:C57,D4:D57=0)
My formula result is 0 which is not correct.
What am I doing wrong??
Please help!!!
---
Message posted from http://www.ExcelForum.com/