sumproduct formula problem

Hi guys,

I'm trying to get a formula to tell me this;

if column E="bedding", count the number of 0's in column M.

sumproduct seems logical? this is what i have so far (sorry unable to upload example due to work restrictions).

Please Login or Register  to view this content.

not sure why it isn't working?

Hi

Try without "",in zero value.

=SUMPRODUCT((Sheet1!E2:E29029="Bedding")*(Sheet1!M2:M29029=0))

Hi,

Take out the quote marks around the zero

If you don't want to count blanks as well as zeros then add an extra element
(Sheet1!M2:M29029<>"")

Regards

Hi,

You didn't mention the #N/A in the original post. You just said it wasn't working. Clearly it is but identifying a problem and returning an error.
I suggest you filter column M for #N/A values. I'll bet a pound to a penny that one of the column M cells is showing an error.

Regards

..And please let us know this time, if you find your solution, not like the other time.....

http://www.excelforum.com/excel-gene...-problems.html

You are welcome

Eh!

I didn't say you hadn't mentioned an error, I said you hadn't mentioned the fact that the error was '#N/A'. i.e nowhere in your original post was the word '#N/A' used. That's important since it can suggest possible reasons.