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 should sell budget phones in the US?

Discuss in The Lounge

Poll History