If (A1 = "ValueA" & C1 = "ValueB") return the quantity of matches

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using data looking something similar to below....

Column A Column B Column C
Red 1 Santa
Blue 1 Santa
Red 1 Elf

What formula do I use if I want to count the amount of times Col A = Red and
Col C = Santa?

Had no luck so far using variations of....
=SUM(IF(Data!H:H="Red",IF(Data!J:J="Santa",1,0)))
 
Using data looking something similar to below....
Column A Column B Column C
Red 1 Santa
Blue 1 Santa
Red 1 Elf

What formula do I use if I want to count the amount of times Col A = Red
and
Col C = Santa?

Had no luck so far using variations of....
=SUM(IF(Data!H:H="Red",IF(Data!J:J="Santa",1,0)))
Click to expand...

Try this...

=SUMPRODUCT((A1:A1000="Red")*(C1:C1000="Santa"))

Use a number larger than the largest row of data you will ever have in place
of my 1000s.

Rick
 
THANK YOU!

I've been racking my brains for a while trying to get this to work.
Appreciate the help
 
Back
Top