Sum a column correctly after more info is added by sorting
See my problem is that I have multiple groups in date ranges. For Example:
A B C
1 50 1/5
2 25 1/5
3 75 1/6
4 100 1/7
5 100 1/9
6 350
7 25 1/12
8 25 1/13
9 50 1/15
10 100 1/16
11 200
The groups of date ranges are never set to how many rows it will take up.
So, in the example above, I need Cell C11 to activate when A11 = , but I
only need it to sum up A7:A10. And tomorrow if I add three more numbers in
that date range I will need it to jump down and have Cell C14 activate when
A14 = and then total from A7:A13.
Is that possible?
"Bernie Deitrick" wrote:
In C81, enter this
=IF(A81="",SUM($A$81:A81)-SUM($C$1:C80),"")
and copy down.
HTH,
Bernie
MS Excel MVP
"Soulscream" wrote in message
...
I have a spread sheet that is laid out in sections grouped by dates. I am
trying to create a function that will sum a particular column correctly and
expand even when new information is added and the dates are resorted.
Example: Cell C100 should sum the column A80:A99, but when new information
is added and then the spread sheet is resorted the column will expand to
A80:A100 in which case Cell C101 would then properly total A80:A100 and Cell
C100 would go back to being blank.
I think there may be a way to count between blank cells and on my
spreadsheet Cell A79 will always be blank, and whatever cell in the A column
of the same row as my C cell with my formula (ie. A100 or A101) will always
be blank.
If anyone has any ideas your help would be greatly appreciated.
Thank you.
|