countif & and
 

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!!!!!!!

=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

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

Does one of these:

=SUMPRODUCT(--(B2:B56=79),--(--G2:G56=0))

=SUMPRODUCT(--(B2:B56=79),--(G2:G56="0000"))

meet the expectation?

lost!! wrote:
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