Hi!

Try this:

=SUMPRODUCT(--(A1:A100="Yes"),--(B1:B100=1))

Biff

"Agallagher" wrote in message
...
I need to find the total if conditions in two columns are met. I'm doing a
school lottery for enrollment and need to see how many students met the
criteria "yes" in a specific grade level "1".

Example:

Column A Column B
Yes 1
3
Yes 1
1

I'm looking for the total number of times yes and 1 are in the same row.
Here it is 2 times.

Thanks for any help anyone can give me.