SUM between upper and lower ranges of cumulative figures

D

dma1976

New Member
Joined
Jun 18, 2013
Messages
2
Dear All,

I hope it is possible that you could help me with the following problem. This has been bugging me for some time now.

I have a table that lists days spent on an activity by month (D7:D17). The next column keeps a running total of these days (E7:E17). From the cumulative totals (E7:E17) I need to split the days into categories of 0 to 45 days, 46 to 60 days and finally 61+ days.

I have managed to use formulae to calculate the 0 to 45 days (F7:F17) and 60+ days (N7:H17), based on the cumulative column, but I'm having trouble with the 46 to 60 days formula (G7:G17). I'm hoping a formula can be created that looks at the cumulative days already spent and if the cumulative days up to that month are over 45 days but less than 60, it will add in the days within that range for the month in question.

I know that the results in the following cells should be:
G7:G9 = all 0
G10 = 2
G11 = 0
G12 = 13
G13:G17 = all 0
Total (cell G18)= 15 days

At the top of the table there are some input boxes (E2:H4). I'd hope that the formula can reference these cells so if the need to change the ranges occurs, I can simply change these cells.

[TABLE="width: 381"]
<tbody>[TR]
[TD="class: xl66, width: 83, bgcolor: transparent"][/TD]
[TD="class: xl66, width: 51, bgcolor: transparent"][/TD]
[TD="class: xl67, width: 126, bgcolor: transparent"]Input Lower Value
[/TD]
[TD="class: xl68, width: 82, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl68, width: 82, bgcolor: transparent, align: right"]46
[/TD]
[TD="class: xl68, width: 82, bgcolor: transparent, align: right"]61
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"]Input Upper Value
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]45
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]60
[/TD]
[TD="class: xl69, bgcolor: transparent"]∞
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: transparent"]Month
[/TD]
[TD="class: xl71, bgcolor: transparent"]Days
[/TD]
[TD="class: xl71, bgcolor: transparent"]Cumulative Days
[/TD]
[TD="class: xl71, bgcolor: transparent"]0 - 45 days
[/TD]
[TD="class: xl71, bgcolor: transparent"]46 - 60 days
[/TD]
[TD="class: xl71, bgcolor: transparent"]60 + days
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]Jan-13
[/TD]
[TD="class: xl70, bgcolor: transparent"]12
[/TD]
[TD="class: xl70, bgcolor: transparent"]12
[/TD]
[TD="class: xl70, bgcolor: transparent"]12
[/TD]
[TD="class: xl73, bgcolor: #E0F595"][/TD]
[TD="class: xl70, bgcolor: transparent"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]Feb-13
[/TD]
[TD="class: xl70, bgcolor: transparent"]21
[/TD]
[TD="class: xl70, bgcolor: transparent"]33
[/TD]
[TD="class: xl70, bgcolor: transparent"]21
[/TD]
[TD="class: xl73, bgcolor: #E0F595"][/TD]
[TD="class: xl70, bgcolor: transparent"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]Mar-13
[/TD]
[TD="class: xl70, bgcolor: transparent"]14
[/TD]
[TD="class: xl70, bgcolor: transparent"]47
[/TD]
[TD="class: xl70, bgcolor: transparent"]12
[/TD]
[TD="class: xl73, bgcolor: #E0F595"][/TD]
[TD="class: xl70, bgcolor: transparent"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]Apr-13
[/TD]
[TD="class: xl70, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, bgcolor: transparent"]47
[/TD]
[TD="class: xl70, bgcolor: transparent"]0
[/TD]
[TD="class: xl73, bgcolor: #E0F595"][/TD]
[TD="class: xl70, bgcolor: transparent"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]May-13
[/TD]
[TD="class: xl70, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, bgcolor: transparent"]47
[/TD]
[TD="class: xl70, bgcolor: transparent"]0
[/TD]
[TD="class: xl73, bgcolor: #E0F595"][/TD]
[TD="class: xl70, bgcolor: transparent"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]Jun-13
[/TD]
[TD="class: xl70, bgcolor: transparent"]28
[/TD]
[TD="class: xl70, bgcolor: transparent"]75
[/TD]
[TD="class: xl70, bgcolor: transparent"]0
[/TD]
[TD="class: xl73, bgcolor: #E0F595"][/TD]
[TD="class: xl70, bgcolor: transparent"]15
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]Jul-13
[/TD]
[TD="class: xl70, bgcolor: transparent"]27
[/TD]
[TD="class: xl70, bgcolor: transparent"]102
[/TD]
[TD="class: xl70, bgcolor: transparent"]0
[/TD]
[TD="class: xl73, bgcolor: #E0F595"][/TD]
[TD="class: xl70, bgcolor: transparent"]27
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]Aug-13
[/TD]
[TD="class: xl70, bgcolor: transparent"]27
[/TD]
[TD="class: xl70, bgcolor: transparent"]129
[/TD]
[TD="class: xl70, bgcolor: transparent"]0
[/TD]
[TD="class: xl73, bgcolor: #E0F595"][/TD]
[TD="class: xl70, bgcolor: transparent"]27
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]Sep-13
[/TD]
[TD="class: xl70, bgcolor: transparent"]31
[/TD]
[TD="class: xl70, bgcolor: transparent"]160
[/TD]
[TD="class: xl70, bgcolor: transparent"]0
[/TD]
[TD="class: xl73, bgcolor: #E0F595"][/TD]
[TD="class: xl70, bgcolor: transparent"]31
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]Oct-13
[/TD]
[TD="class: xl70, bgcolor: transparent"]11
[/TD]
[TD="class: xl70, bgcolor: transparent"]171
[/TD]
[TD="class: xl70, bgcolor: transparent"]0
[/TD]
[TD="class: xl73, bgcolor: #E0F595"][/TD]
[TD="class: xl70, bgcolor: transparent"]11
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]Nov-13
[/TD]
[TD="class: xl70, bgcolor: transparent"]3
[/TD]
[TD="class: xl70, bgcolor: transparent"]174
[/TD]
[TD="class: xl70, bgcolor: transparent"]0
[/TD]
[TD="class: xl73, bgcolor: #E0F595"][/TD]
[TD="class: xl70, bgcolor: transparent"]3
[/TD]
[/TR]
[TR]
[TD="class: xl74, bgcolor: transparent"]Total
[/TD]
[TD="class: xl75, bgcolor: transparent"]174
[/TD]
[TD="class: xl75, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"]45
[/TD]
[TD="class: xl75, bgcolor: transparent"]0
[/TD]
[TD="class: xl75, bgcolor: transparent"]114
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, width: 164, bgcolor: transparent, colspan: 2"]<v:shapetype id="_x0000_t75" stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" o:preferrelative="t" o:spt="75" coordsize="21600,21600"> <v:stroke joinstyle="miter"> <v:formulas> <v:f eqn="if lineDrawn pixelLineWidth 0"> <v:f eqn="sum @0 1 0"> <v:f eqn="sum 0 0 @1"> <v:f eqn="prod @2 1 2"> <v:f eqn="prod @3 21600 pixelWidth"> <v:f eqn="prod @3 21600 pixelHeight"> <v:f eqn="sum @0 0 1"> <v:f eqn="prod @6 1 2"> <v:f eqn="prod @7 21600 pixelWidth"> <v:f eqn="sum @8 21600 0"> <v:f eqn="prod @7 21600 pixelHeight"> <v:f eqn="sum @10 21600 0"> </v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:formulas> <v:path o:connecttype="rect" gradientshapeok="t" o:extrusionok="f"> <o:lock aspectratio="t" v:ext="edit"> </o:lock></v:path></v:stroke></v:shapetype>
[/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent, colspan: 2"]This total should be 15
[/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]


Any help that can be offered would be most appreciated.
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
Sort by date Sort by votes
Dear All,

I entered the worng cell references in my first post. I've updated here.

I have a table that lists days spent on an activity by month (B6:B16). The next column keeps a running total of these days (C6:C16). From the cumulative totals (C6:C16) I need to split the days into categories of 0 to 45 days, 46 to 60 days and finally 61+ days.

I have managed to use formulae to calculate the 0 to 45 days (D6:D16) and 60+ days (F6:F16), based on the cumulative column, but I'm having trouble with the 46 to 60 days formula (E6:E16). I'm hoping a formula can be created that looks at the cumulative days already spent and if the cumulative days up to that month are over 45 days but less than 60, it will add in the days within that range for the month in question.

I know that the results in the following cells should be:
E6:E8 = all 0
E9 = 2
E10 = 0
E11 = 13
E12:E16 = all 0
Total (cell E17)= 15 days

At the top of the table there are some input boxes (D1:F2). I'd hope that the formula can reference these cells so if the need to change the ranges occurs, I can simply change these cells.

[TABLE="width: 381"]
<tbody>[TR]
[TD="class: xl66, width: 83, bgcolor: transparent"][/TD]
[TD="class: xl66, width: 51, bgcolor: transparent"][/TD]
[TD="class: xl67, width: 126, bgcolor: transparent"]Input Lower Value
[/TD]
[TD="class: xl68, width: 82, bgcolor: transparent, align: right"]0
[/TD]
[TD="class: xl68, width: 82, bgcolor: transparent, align: right"]46
[/TD]
[TD="class: xl68, width: 82, bgcolor: transparent, align: right"]61
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"]Input Upper Value
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]45
[/TD]
[TD="class: xl68, bgcolor: transparent, align: right"]60
[/TD]
[TD="class: xl69, bgcolor: transparent"]∞
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: transparent"]Month
[/TD]
[TD="class: xl71, bgcolor: transparent"]Days
[/TD]
[TD="class: xl71, bgcolor: transparent"]Cumulative Days
[/TD]
[TD="class: xl71, bgcolor: transparent"]0 - 45 days
[/TD]
[TD="class: xl71, bgcolor: transparent"]46 - 60 days
[/TD]
[TD="class: xl71, bgcolor: transparent"]60 + days
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]Jan-13
[/TD]
[TD="class: xl70, bgcolor: transparent"]12
[/TD]
[TD="class: xl70, bgcolor: transparent"]12
[/TD]
[TD="class: xl70, bgcolor: transparent"]12
[/TD]
[TD="class: xl73, bgcolor: #E0F595"][/TD]
[TD="class: xl70, bgcolor: transparent"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]Feb-13
[/TD]
[TD="class: xl70, bgcolor: transparent"]21
[/TD]
[TD="class: xl70, bgcolor: transparent"]33
[/TD]
[TD="class: xl70, bgcolor: transparent"]21
[/TD]
[TD="class: xl73, bgcolor: #E0F595"][/TD]
[TD="class: xl70, bgcolor: transparent"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]Mar-13
[/TD]
[TD="class: xl70, bgcolor: transparent"]14
[/TD]
[TD="class: xl70, bgcolor: transparent"]47
[/TD]
[TD="class: xl70, bgcolor: transparent"]12
[/TD]
[TD="class: xl73, bgcolor: #E0F595"][/TD]
[TD="class: xl70, bgcolor: transparent"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]Apr-13
[/TD]
[TD="class: xl70, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, bgcolor: transparent"]47
[/TD]
[TD="class: xl70, bgcolor: transparent"]0
[/TD]
[TD="class: xl73, bgcolor: #E0F595"][/TD]
[TD="class: xl70, bgcolor: transparent"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]May-13
[/TD]
[TD="class: xl70, bgcolor: transparent"]0
[/TD]
[TD="class: xl70, bgcolor: transparent"]47
[/TD]
[TD="class: xl70, bgcolor: transparent"]0
[/TD]
[TD="class: xl73, bgcolor: #E0F595"][/TD]
[TD="class: xl70, bgcolor: transparent"]0
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]Jun-13
[/TD]
[TD="class: xl70, bgcolor: transparent"]28
[/TD]
[TD="class: xl70, bgcolor: transparent"]75
[/TD]
[TD="class: xl70, bgcolor: transparent"]0
[/TD]
[TD="class: xl73, bgcolor: #E0F595"][/TD]
[TD="class: xl70, bgcolor: transparent"]15
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]Jul-13
[/TD]
[TD="class: xl70, bgcolor: transparent"]27
[/TD]
[TD="class: xl70, bgcolor: transparent"]102
[/TD]
[TD="class: xl70, bgcolor: transparent"]0
[/TD]
[TD="class: xl73, bgcolor: #E0F595"][/TD]
[TD="class: xl70, bgcolor: transparent"]27
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]Aug-13
[/TD]
[TD="class: xl70, bgcolor: transparent"]27
[/TD]
[TD="class: xl70, bgcolor: transparent"]129
[/TD]
[TD="class: xl70, bgcolor: transparent"]0
[/TD]
[TD="class: xl73, bgcolor: #E0F595"][/TD]
[TD="class: xl70, bgcolor: transparent"]27
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]Sep-13
[/TD]
[TD="class: xl70, bgcolor: transparent"]31
[/TD]
[TD="class: xl70, bgcolor: transparent"]160
[/TD]
[TD="class: xl70, bgcolor: transparent"]0
[/TD]
[TD="class: xl73, bgcolor: #E0F595"][/TD]
[TD="class: xl70, bgcolor: transparent"]31
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]Oct-13
[/TD]
[TD="class: xl70, bgcolor: transparent"]11
[/TD]
[TD="class: xl70, bgcolor: transparent"]171
[/TD]
[TD="class: xl70, bgcolor: transparent"]0
[/TD]
[TD="class: xl73, bgcolor: #E0F595"][/TD]
[TD="class: xl70, bgcolor: transparent"]11
[/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"]Nov-13
[/TD]
[TD="class: xl70, bgcolor: transparent"]3
[/TD]
[TD="class: xl70, bgcolor: transparent"]174
[/TD]
[TD="class: xl70, bgcolor: transparent"]0
[/TD]
[TD="class: xl73, bgcolor: #E0F595"][/TD]
[TD="class: xl70, bgcolor: transparent"]3
[/TD]
[/TR]
[TR]
[TD="class: xl74, bgcolor: transparent"]Total
[/TD]
[TD="class: xl75, bgcolor: transparent"]174
[/TD]
[TD="class: xl75, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"]45
[/TD]
[TD="class: xl75, bgcolor: transparent"]0
[/TD]
[TD="class: xl75, bgcolor: transparent"]114
[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, width: 164, bgcolor: transparent, colspan: 2"]<v:shapetype id="_x0000_t75" stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" o:preferrelative="t" o:spt="75" coordsize="21600,21600"><v:stroke joinstyle="miter"><v:formulas><v:f eqn="if lineDrawn pixelLineWidth 0"><v:f eqn="sum @0 1 0"><v:f eqn="sum 0 0 @1"><v:f eqn="prod @2 1 2"><v:f eqn="prod @3 21600 pixelWidth"><v:f eqn="prod @3 21600 pixelHeight"><v:f eqn="sum @0 0 1"><v:f eqn="prod @6 1 2"><v:f eqn="prod @7 21600 pixelWidth"><v:f eqn="sum @8 21600 0"><v:f eqn="prod @7 21600 pixelHeight"><v:f eqn="sum @10 21600 0"></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:formulas><v:path o:connecttype="rect" gradientshapeok="t" o:extrusionok="f"><o:lock aspectratio="t" v:ext="edit"></o:lock></v:path></v:stroke></v:shapetype>
[/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: transparent, colspan: 2"]This total should be 15
[/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]


Any help that can be offered would be most appreciated.
 
Upvote 0
You must log in or register to reply here.

Similar threads

P
  • Solved
Sum Multiple Rows Based on Upper and Lower Limit
Replies
8
Views
483
awoohaw
awoohaw
R
  • Solved
Ignore blanks for a SUM
Replies
2
Views
115
Rex987456
R
J
  • Solved
populating dates of the current month with a formula
Replies
6
Views
350
jbrown021286
J
K
  • Question Question
Excel Pivot table Time Values is not populating same as Source Sheet
Replies
1
Views
600
awoohaw
awoohaw
N
  • Solved
VBA to delete range between 2 used ranges.
Replies
9
Views
319
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,223,893
Messages
6,175,242
Members
452,623
Latest member
russelllowellpercy

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top