I have two columns C and D.

I want to count the items in C only if the sales volume in column D ar
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

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/

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/

That works, but I don't understand the logic of the formula??

Why am I using a SUMPRODUCT to count??

Please help me understand?

--
Message posted from http://www.ExcelForum.com

Hi
see:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--
Regards
Frank Kabel
Frankfurt, Germany

"tratliff " schrieb im
Newsbeitrag ...
That works, but I don't understand the logic of the formula??

Why am I using a SUMPRODUCT to count??

Please help me understand??


---
Message posted from http://www.ExcelForum.com/

Thanks Frank...I appreciate the info

--
Message posted from http://www.ExcelForum.com