COUNT DATA

[Mark]

Hi,

I have problem with count all item1(column B) with value 1
(column A) and give result in cell "C1"
How describe function without any filter.

A B
1 item1
0 item1
1 item2
1 item2
1 item1
0 item3
etc....


Regards
Mark

 

[Peo Sjoblom]

One way

=SUMPRODUCT(--(A2:A50=1),--(B2:B50="item1"))

 

[Mark]

Thanks Peo for indication!
What's mean "--" in your formula?
It's work by similar formula with sumproduct.
I've excel 2k - noenglish

Best Regards
Mark



What