Excell: Sum Double IF statment

August 13, 2009 at 09:54:32
Specs: Windows XP
I have an running spreadsheet with 2 columns I would like it to read.

Column A are dates: 8/1, 9/1, 10/1.
Column F are results: Enrolled, N/I, N/E

I want it to interpret the results each as 1 so I can total/compare them and make charts.

I would like it to read the month to compare month to month results.

I want it to ask: "IF Column A = 8/1, and Column F = Enrolled, then read Enrolled as 1 and compute the sum.

Then,"IF Column A = 9/1, and Column F = Enrolled, then read Enrolled as 1 and compute the sum.

I've tried: =IF(A2:A20000=8/1,SUM(IF(F2:F20000="Enrolled",1)))

But I can't figure it out.

Any Ideas?


See More: Excell: Sum Double IF statment

Report •


#1
August 13, 2009 at 11:37:59
Do you want 1 if the Date matches plus 1 if Enrolled matches (Sum = 2) or do you just want 1 if they both match?

This'll get you 2:

=SUM(IF(A1=DATEVALUE("8/1/2009"),1,0),IF(B1="Enrolled",1,0))

This'll get you 1:

=IF(AND(A1=DATEVALUE("8/1/2009"),B1="Enrolled"),1,0)

Note: the DATEVALUE function might not be needed...it'll all depends on how you have your cells formatted.


Report •
Related Solutions


Ask Question