Hi,
I have the following formulas in a sheet called Reading.
=COUNTIFS(ReadingGrade,Reading!$AZ6,ReadingVicCurrJ,"=0")
=LEFT($C$2,1) = "0"
In another sheet called calculations I would like to combine these two formulas. I would like it to check C2 to see if it contains 1. If it does I would like it to check the named range ReadingGrade to see if it matches AZ6. If it does I want it check the named range ReadingSemester1 and count all values that equal 0.
I've tried different variations but haven't had any luck. I'm also not sure if it is an issue using a named range from a different sheet.
Any help would be greatly appreciated.
Bookmarks