Try:

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

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



In article ,
SDH wrote:

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