Sum Product values meeting 2 criteria

  • Thread starter Thread starter Jan
  • Start date Start date
J

Jan

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!
 
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.
 
(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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using sumifs to sum based on month, and criteria 13
SUMIF with criteria "<>" & "=" 4
Sum total using Sumproduct if two criteria met 5
Sum columns up to vlookup value 3
Add Values that Match 2 Criteria Q 1
2 Criteria Summing 3
SumProd from 2 columns and date range 6
SUMPRODUCT, MAX, Few Criteria 3

Back
Top