|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.