You must have other fields which enable you to sort the data that way,
so please give details.

Also, do you add the blank row manually between each block?

Pete

On Jan 21, 7:56*pm, Soulscream
wrote:
Sorry, Microsoft doesn't show my spaces correctly. Please see below and
ignore the periods as spaces. Hopefully, this time it will display correctly. *.....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.- Hide quoted text -

- Show quoted text -