I just tried that but I get a value of 0 instead of 3.


"Dave Peterson" wrote:

=sumproduct(--(b2:b56=79),--(g2:g56=0))



lost!! wrote:

Hi there,
is it possible to use countif & and together? I've tried many formats and
can't get it to work.
If should count if the range b2:b56 has a value of 79 and range g2:g56 has a
value of 0000: No errors detected.

Any ideas?

Would be greatly appreciated!!!!!!!

--

Dave Peterson