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

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

"Raymond" wrote:

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

Raymond wrote:
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 he

http://www.contextures.com/xlFunctio...tml#SumProduct

OOPPss
Sorry I misread your post use this formula

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

"Eduardo" wrote:

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

"Raymond" wrote:

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

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

"Eduardo" wrote in message
...
Hi,
=sumproduct((B7:B25="a")+(C7:C25="b"))

"Raymond" wrote:

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