View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Agallagher
 
Posts: n/a
Default sum if conditions in two columns are met?

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.