=sumproduct(--(A2:A200=sex),--(B2:B200=age),C2:C200)

--
HTH

Bob Phillips

"towl" wrote in message
...

Hi, I have a table full of data, and I want to do a sum on the data, if
two conditions are met, for example:

3 Columns A , B, C contain:
In A Sex
In B Age
In C Salary

Down the rows it is Male or Female persons age and Salary.


I then have another table with criteria in it, again 3 columns ABC
A Sex
B Age
C hopeful formula result

In c I am after the sum of all the salaries of the two conditions in
A&B, so if A is male and B is 24, I want the formula to sum up all the
salaries of Male 24 year olds in the origional table.

I know this could be done in lotus, but can it be done in Excel?

Any help appreciated.


--
towl
------------------------------------------------------------------------
towl's Profile:
http://www.excelforum.com/member.php...o&userid=26340
View this thread: http://www.excelforum.com/showthread...hreadid=396082