Count or Sumif formula
 

How would I write a formula for the example below

a b
1 m scaf
2 b scaf
3 b scaf
4 b lab

I am wanting to create a count if to where I am counting the b's in a that
have scaf. The answer should be 2.

Thank you
Jeremy

Count or Sumif formula
 

Try this =SUMPRODUCT(--(A1:A4="b"),--(B1:B4="scarf"))



On Jun 10, 10:41 am, Jeremy wrote:
How would I write a formula for the example below

a b
1 m scaf
2 b scaf
3 b scaf
4 b lab

I am wanting to create a count if to where I am counting the b's in a that
have scaf. The answer should be 2.

Thank you
Jeremy

Count or Sumif formula
 

=SUMPRODUCT(--(A2:A10="b"),--(B2:B10="scaf"))


--


Regards,


Peo Sjoblom


"Jeremy" wrote in message
...
How would I write a formula for the example below

a b
1 m scaf
2 b scaf
3 b scaf
4 b lab

I am wanting to create a count if to where I am counting the b's in a that
have scaf. The answer should be 2.

Thank you
Jeremy