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