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