countif & and

L

lost!!

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

Dave Peterson

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



lost!! said:
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!!!!!!!
Click to expand...
 
A

Aladin Akyurek

Does one of these:

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

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

meet the expectation?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

countifs Function not giving desired result with date criteria 2
COUNTIFS using multiple named ranges in the criteria 0
Multiple arguments 3
Excel Countif Function - Calculating Between Two Sets of Values 3
COUNTIFS (the numbers in a column, when subtracted meet a certain criteria) 1
using countif in a filtered range 12
Excel 2010 countifs for date range 3
Countif with a Range of criteria 8

Top