Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy cells to variable number of rows | Excel Discussion (Misc queries) | |||
Summing a variable number of rows | Excel Discussion (Misc queries) | |||
change the number of rows to a variable | Excel Programming | |||
insert variable number of rows | Excel Programming | |||
Paste to variable number of rows | Excel Programming |