Thread: If (A1 = "ValueA" & C1 = "ValueB") return the quantity of matches
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DaveC DaveC is offline
external usenet poster
  
Posts: 22
Default If (A1 = "ValueA" & C1 = "ValueB") return the quantity of matches
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)))

Reply With QuoteReply With Quote