Sum to Defined level

[Nate Walsh]

I was wondering how I could add a column of numbers up to a defined level
(250000.00) then add the remaining numbers in the column?

[Max]

One way to try ..

Assume the col of numbers is in col A, A1 down

Put in B1: =SUM($A$1:A1)
Copy B1 down

(Col B returns a cumulative sum)

Put in C1: =SUMIF(B:B,"<=250000",A:A)
Put in D1: =SUM(A:A)-C1

C1 returns the cumulative sum of col A
up to the defined level of 250000

D1 returns the sum of the remaining numbers in col A

You could also have C1 point to a cell instead
for the defined level, say to cell E1:

In C1: =SUMIF(B:B,"<="&E1,A:A)
where E1 will contain, say: 250000

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"Nate Walsh" <[email protected]> wrote in message
news:[email protected]...
> I was wondering how I could add a column of numbers up to a defined level
> (250000.00) then add the remaining numbers in the column?

[CLR]

=IF(SUM(A:A)>250000,SUM(A:A)-250000,SUM(A:A))

Vaya con Dios,
Chuck, CABGx3



"Nate Walsh" <[email protected]> wrote in message
news:[email protected]...
> I was wondering how I could add a column of numbers up to a defined level
> (250000.00) then add the remaining numbers in the column?