I am trying to calculate 2 named ranges and it is giving me a fit so I was hoping someone could help.
On sheet 1 I have a named range called StudentClass. (Nursery, 1st - 2nd Grade, etc.)
On sheet 2 I have a named range called SeptemberAttendace. (P,E,U,N)
On sheet 3 I am trying to count the September Attendance as follows
But I don't get a value and it should be 2.