Hi i am having a SUMPRODUCT COUNTIF problem. Previously the formula was
missing a single quotation mark between the double quotation marks. Once
this was implemented i have had no problems However, i have been asked to
make a similar sheet. The sheets have different names so i have modified the
range but i cannot get the formula to work. It is:

=SUMPRODUCT(COUNTIF(INDIRECT("'"&Universities&"'!C 4"),"Pass"))

It keeps coming up with the #REF! error.