SUMPRODUCT assistance

[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"))

 

[JE McGimpsey]

Try:

=SUMPRODUCT(--('Gazettals 06-07'!F2:F1399>=43),--(J2:J1399="AGIMO"))

See http://www.mcgimpsey.com/excel/doubleneg.html