Hi
try
=SUMPRODUCT(--(C4:C57<""),--(D4:D57=0))
--
Regards
Frank Kabel
Frankfurt, Germany
"tratliff " schrieb im
Newsbeitrag ...
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/