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?

Do you want 1 if the Date matches plus1 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.

Ask Your Question

Weekly Poll

Do you think Google Fiber has a strong future?

Discuss in The Lounge

Poll History