S
SDH
I am trying to count the number of occurences where Column F has a value >=43
and the corresponding row in Column J has the word AGIMO.
I have the following but it doesn't seem to return a value. Am i on the
right track???
=SUMPRODUCT(('Gazettals 06-07'!F2:F1399>=43),(J2:J1399="AGIMO"))
and the corresponding row in Column J has the word AGIMO.
I have the following but it doesn't seem to return a value. Am i on the
right track???
=SUMPRODUCT(('Gazettals 06-07'!F2:F1399>=43),(J2:J1399="AGIMO"))