(all in one line)
=SUMPRODUCT(
--('[Cognos Links.xls]Current Month'!$A1:$A5000=G6),
--('[Cognos Links.xls]Current Month'!$B1:$B5000=G9),
'[Cognos Links.xls]Current Month'!$F1:$F5000)

If this post helps click Yes
---------------
Jacob Skaria


"Jan" wrote:

I am trying to sum column F for entries where the following conditions are
met:-

Column A contains text value matching G6
+
Column B contains text value matching G9

=SUMPRODUCT((--'[Cognos Links.xls]Current Month'!$A1:$A5000=G6),--('[Cognos
Links.xls]Current Month'!$B1:$B5000=G9),'[Cognos Links.xls]Current
Month'!$F1:$F5000)

Much appreciated!