R Raymond Sep 15, 2009 #1 I am trying to do a countif formula using multiple if statements. For example: if B7:B25="a" and C7:C25="b" then A= count
I am trying to do a countif formula using multiple if statements. For example: if B7:B25="a" and C7:C25="b" then A= count
G Glenn Sep 15, 2009 #3 Raymond said: I am trying to do a countif formula using multiple if statements. For example: if B7:B25="a" and C7:C25="b" then A= count Click to expand... Look here: http://www.contextures.com/xlFunctions04.html#SumProduct
Raymond said: I am trying to do a countif formula using multiple if statements. For example: if B7:B25="a" and C7:C25="b" then A= count Click to expand... Look here: http://www.contextures.com/xlFunctions04.html#SumProduct
E Eduardo Sep 15, 2009 #4 OOPPss Sorry I misread your post use this formula =SUMPRODUCT((A1:A4="A")*(B1:B4="B"))
D David Biddulph Sep 15, 2009 #5 Should that + sign be a * ? -- David Biddulph Eduardo said: Hi, =sumproduct((B7:B25="a")+(C7:C25="b")) Click to expand...
Should that + sign be a * ? -- David Biddulph Eduardo said: Hi, =sumproduct((B7:B25="a")+(C7:C25="b")) Click to expand...