Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sum on conditions.....
Hello again, I have a new question for you, guru. This is my worksheet Column A Column B Member A 5 f Member B 5 m Member C 5 f As you can see, for each "member" I need to specify 2 values : a numeric one (let's say "age") and string one ("f"="female" or "m"="man"). My problem is to sum the ages for all "female" (f) members .... and sum of ages for "man" (m) members. Of course, it would be simplier to have Member A 5 f Member B 5 i Member C 5 f but I cannot change the spreadsheet as it is now. How can achieve this result? thanks a lot *pimar -- pimar ------------------------------------------------------------------------ pimar's Profile: http://www.excelforum.com/member.php...fo&userid=5386 View this thread: http://www.excelforum.com/showthread...hreadid=374137 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting occurrences of multiple conditions | Excel Discussion (Misc queries) | |||
How do I count number of cels the matches 2 conditions ? | Excel Worksheet Functions | |||
should be possible to add more conditions to conditional formatti. | Excel Discussion (Misc queries) | |||
How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions | |||
average on 2 conditions | Excel Worksheet Functions |