Sum cells with variable number of rows
 

Hello,
Have a spreadsheet with 7000 rows, with a number of pieces in column G,
each having a Date in column A. Have used an IF worksheet function to
repeat the Date in column M of the last instance of each date. Need to Sum
the range of cells in column G that match the same date and place the result
in column N, beside the repeated Date. Can supply a 25 row snippet if need
it. Thanks for any help.
LSM

Sum cells with variable number of rows
 

I am assuming that the data is sorted by date, and that all the cells in
column M except the last one for each date do not contain a date. In other
words, I am guessing your IF formula in column M is something like
=IF(A6<A7,A6,"") for M6. If these assumptions are correct, then you can
enter the following formula in column N and copy it down for all your data
rows. Here it is for N6:

=SUMIF(A:A,M6,G:G)

Hope this helps,

Hutch

"L Martin" wrote:

Hello,
Have a spreadsheet with 7000 rows, with a number of pieces in column G,
each having a Date in column A. Have used an IF worksheet function to
repeat the Date in column M of the last instance of each date. Need to Sum
the range of cells in column G that match the same date and place the result
in column N, beside the repeated Date. Can supply a 25 row snippet if need
it. Thanks for any help.
LSM

Sum cells with variable number of rows
 

Worked like a charm! Thanks for your help.
"Tom Hutchins" wrote in message
...
I am assuming that the data is sorted by date, and that all the cells in
column M except the last one for each date do not contain a date. In other
words, I am guessing your IF formula in column M is something like
=IF(A6<A7,A6,"") for M6. If these assumptions are correct, then you can
enter the following formula in column N and copy it down for all your data
rows. Here it is for N6:

=SUMIF(A:A,M6,G:G)

Hope this helps,

Hutch

"L Martin" wrote:

Hello,
Have a spreadsheet with 7000 rows, with a number of pieces in column
G,
each having a Date in column A. Have used an IF worksheet function to
repeat the Date in column M of the last instance of each date. Need to
Sum
the range of cells in column G that match the same date and place the
result
in column N, beside the repeated Date. Can supply a 25 row snippet if
need
it. Thanks for any help.
LSM

Sum cells with variable number of rows
 

I'll have a look if you like. send to

Lee

L Martin wrote:
*Hello,
Have a spreadsheet with 7000 rows, with a number of pieces in column
G,
each having a Date in column A. Have used an IF worksheet function
to
repeat the Date in column M of the last instance of each date. Need
to Sum
the range of cells in column G that match the same date and place the
result
in column N, beside the repeated Date. Can supply a 25 row snippet if
need
it. Thanks for any help.
LSM *



--
roundabout
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message2425171.html