| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum Product values meeting 2 criteria
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum Product values meeting 2 criteria
(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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Identifying A Pattern Of Values Meeting Specific Criteria | Excel Discussion (Misc queries) | |||
| calculation based on meeting two criteria | Excel Discussion (Misc queries) | |||
| Sumif problems - meeting 2 criteria then sum | Excel Discussion (Misc queries) | |||
| how to sum highest ranking values meeting criteria within a limit? | Excel Discussion (Misc queries) | |||
| COUNTIF MEETING TWO CRITERIA eg>5 AND <10.1 | Excel Worksheet Functions | |||
Linear Mode
