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
|