I have a formulas similar to theses in several places up and down my sheet
In D8 I have =SUM(D3:D7)
In D17 I have =SUM(D9:D16)
In D27 I have =SUM(D18:D26)
In D33 I have =SUM(D28:D32)
D3 - D7, etc. each have either a typed in value or a value generated by a formula
There's a lot of them going down to about row 700 and there's no normalcy or pattern to determine how many of the lines above need to be totaled. It's set by groups listed in column B. Sometimes there will be 2 or 3 in a group, sometimes there may be 7, 8 or 11 or maybe only 1.
Rather than manually typing in the formula in the 85 or so cells it needs to go in, is there another way to do this? Cells C8, C17, C27, C33 etc. are all empty so I could put TOTAL or something else there to help Identify where the break is if needed.
Thanks in advance
In D8 I have =SUM(D3:D7)
In D17 I have =SUM(D9:D16)
In D27 I have =SUM(D18:D26)
In D33 I have =SUM(D28:D32)
D3 - D7, etc. each have either a typed in value or a value generated by a formula
There's a lot of them going down to about row 700 and there's no normalcy or pattern to determine how many of the lines above need to be totaled. It's set by groups listed in column B. Sometimes there will be 2 or 3 in a group, sometimes there may be 7, 8 or 11 or maybe only 1.
Rather than manually typing in the formula in the 85 or so cells it needs to go in, is there another way to do this? Cells C8, C17, C27, C33 etc. are all empty so I could put TOTAL or something else there to help Identify where the break is if needed.
Thanks in advance