raith99

Junior Member

Posts: 4

Quote:

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

Works perfectly.

Thanks Claus.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Dynamic pivot table linked to dynamic excel spreadsheets	FErd	Excel Worksheet Functions	0	April 29th 10 10:44 PM
Set Print Area with Dynamic Start Point	StonyfieldRob	Excel Programming	1	November 21st 09 12:53 AM
Insert Formatted Row at specific point within Dynamic Range	ksp	Excel Programming	4	June 8th 06 03:44 AM
How to add a fixed point to a dynamic chart	[email protected]	Excel Programming	1	November 11th 05 01:16 PM
select dynamic range with dynamic start point	Juli	Excel Programming	1	August 31st 05 12:05 AM

All times are GMT +1. The time now is 12:09 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us