countif using multiple if statements

[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

 

[Eduardo]

Hi,
=sumproduct((B7:B25="a")+(C7:C25="b"))

 

[Glenn]

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

 

[Eduardo]

OOPPss
Sorry I misread your post use this formula

=SUMPRODUCT((A1:A4="A")*(B1:B4="B"))

 

[David Biddulph]

Should that + sign be a * ?
--
David Biddulph

Hi,
=sumproduct((B7:B25="a")+(C7:C25="b"))