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