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