Sum Product values meeting 2 criteria
I believe your first group has the "--" in wrong place. In its current place,
your trying to convert the text to numbers, and then compare to G6.
=SUMPRODUCT(--('[Cognos Links.xls]Current Month'!$A1:$A5000=G6),--('[Cognos
Links.xls]Current Month'!$B1:$B5000=G9),'[Cognos Links.xls]Current
Month'!$F1:$F5000)
Note also, if row 1 contains header text, this will snag when it tries to
multiply F1 directly.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"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!
|