# 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/EI 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

#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