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