R
Raymond
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
if B7:B25="a" and C7:C25="b" then A= count
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
E
Eduardo
Hi,
=sumproduct((B7:B25="a")+(C7:C25="b"))
=sumproduct((B7:B25="a")+(C7:C25="b"))
G
Glenn
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
Look here:
http://www.contextures.com/xlFunctions04.html#SumProduct
E
Eduardo
OOPPss
Sorry I misread your post use this formula
=SUMPRODUCT((A1:A4="A")*(B1:B4="B"))
Sorry I misread your post use this formula
=SUMPRODUCT((A1:A4="A")*(B1:B4="B"))
D
David Biddulph
Should that + sign be a * ?
--
David Biddulph
--
David Biddulph
Eduardo said:Hi,
=sumproduct((B7:B25="a")+(C7:C25="b"))