Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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!!!!!!! |
#2
|
|||
|
|||
=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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions | |||
Subtotal And Countif | Excel Discussion (Misc queries) | |||
Countif - Countif | Excel Worksheet Functions | |||
Countif ??? | Excel Worksheet Functions | |||
countif, again | Excel Worksheet Functions |