Originally Posted by Claus Busch

Hi,

Am Fri, 10 May 2013 18:54:57 +0100 schrieb raith99:

The problem I have is that I need to sum the income up to the midpoint
so in the first example I need to sum the F column from age 50 to age 57
and in the second from age 55 to 58. I just can't figure out how to do
it.

try:
=SUMIF(A1:A20,"<="&MEDIAN(A1:A20),F1:F20)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2