Add Values that Match 2 Criteria Q

S

Seanie

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
 
D

Don Guillett

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
Click to expand...

=SUMPRODUCT((Country=B9)*(PayType="RATE 1 - 2012")*Salary)
 

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

Index match issue 2
Index & Match Question 1
SUMIF with multiple criteria 5
Finding dates without attention to data formats 3
Multiple lookup values and adding multiple rates across together 5
How to add cell values until a condition changes 3
Match Multiple Criteria and Return values positioned above the zero 6
Loop Through Text and Test for Scenarios Q 31

Top