| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add Values that Match 2 Criteria Q
I'm trying to add up values in a large row of data that meets 2
criteria. I am getting an anser returned of 0, which is incorrect. I must have something wrong in my formula, which is =SUMPRODUCT((Country=B9)*(PayType="RATE 1 - 2012"),(Salary)) The following I have set as named ranges of the data:- Country; PayType and Salary Thus, the above would be explained as:- Sum Total all the 'Salary' values that equal the Specified PayType for all Values that match B9 in the range 'Country' I hope I've exlained the above clearly |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Add Values that Match 2 Criteria Q
On Monday, May 28, 2012 1:42:02 PM UTC-5, Seanie wrote:
I'm trying to add up values in a large row of data that meets 2 criteria. I am getting an anser returned of 0, which is incorrect. I must have something wrong in my formula, which is =SUMPRODUCT((Country=B9)*(PayType="RATE 1 - 2012"),(Salary)) The following I have set as named ranges of the data:- Country; PayType and Salary Thus, the above would be explained as:- Sum Total all the 'Salary' values that equal the Specified PayType for all Values that match B9 in the range 'Country' I hope I've exlained the above clearly =SUMPRODUCT((Country=B9)*(PayType="RATE 1 - 2012")*Salary) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match Multiple Criteria and Return values positioned above the zero | Excel Worksheet Functions | |||
| Count how many criteria in a column match criteria in another colu | Excel Discussion (Misc queries) | |||
| If two criteria match then sum matching values in another column | Excel Worksheet Functions | |||
| Match criteria with an array of criteria | Excel Worksheet Functions | |||
| MATCH Multiple Criteria & Return Previous / Penultimate Match | Excel Worksheet Functions | |||
Linear Mode
