That did not come out right on the page. all of the 1s will be in column k
and that formula will be in column k as well
"vdubluv74" wrote:
Hi, I need a formula, working with excel 2003, and very new to it.
so with those being the last cells this is what I would need the answers to
be
107 144
those are the totals from the 3rd row to the bottom. but if you had 1s in
the next column and then a formula after the last cells i would need 13 to be
the total.
1 4 1
2 5 1
3 6 1
4 7 1
5 8 1
6 9 1
7 10 1
8 11 1
12 1
10 13 1
11 14 1
12 15 1
14 16 1
15 17 1
0 18 1
=sum(xxx)
107 144 13
thanks
"Mike H" wrote:
Hmm,
I suspect were into VB now. Let us assume these are the last cells in
columns I & J. What result do you expect and why?
1 4
2 5
3 6
4 7
5 8
6 9
7 10
8 11
12
10 13
11 14
12 15
14 16
15 17
0 18
Mike
"vdubluv74" wrote:
That worked perfect, but I messed up on what i needed. so here is the updated
version
find the last entry in a cell and calculate the previous 13 cells. the
previous cells may be blank. because i have fomulas in the other cells i
would need something like this.
if (the last cell in column I is greater than 0) then (take the last cell in
column J, next to column I, so if the last cell in I is I10 the formula would
use J10. and add the number in the previous 13 cells in that column)
wow
"Mike H" wrote:
Tr this
=SUM(INDEX(A1:A1000,LARGE(ROW(A1:A1000)*(A1:A1000< 0),13)):A1000)
This an array which must be entered using CTRL+Shift+Enter and not just enter.
If you do it correctly then Excel will put curly brackets around the formula
{}. You can't type these yourself..
Mike
"vdubluv74" wrote:
I am looking for a formula that calculates the last 13 numbers in a column
that are greater than 0. thanks