Sum particular rows of data

[davyj93]

Hi all,

I would like to be able to sum particular rows of data. In my first table below I have 2 columns of data. In the second table I would like to be able to enter a particular time range (e.g. 20 - 40 mins) and use a formula to get the sum of energy within this time range. What formula would I have to use to get the sum? The formula would needs to be able to only use specific rows of data.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]Time[/TD]
[TD="align: center"]Energy[/TD]
[/TR]
[TR]
[TD="align: center"](min)[/TD]
[TD="align: center"](kJ)[/TD]
[/TR]
[TR]
[TD="align: center"]0
[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD="align: center"]50[/TD]
[/TR]
[TR]
[TD="align: center"]15[/TD]
[TD="align: center"]150[/TD]
[/TR]
[TR]
[TD="align: center"]20[/TD]
[TD="align: center"]200[/TD]
[/TR]
[TR]
[TD="align: center"]25[/TD]
[TD="align: center"]260[/TD]
[/TR]
[TR]
[TD="align: center"]30[/TD]
[TD="align: center"]280[/TD]
[/TR]
[TR]
[TD="align: center"]40[/TD]
[TD="align: center"]290[/TD]
[/TR]
[TR]
[TD="align: center"]50[/TD]
[TD="align: center"]350[/TD]
[/TR]
</tbody>[/TABLE]

​

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]Time Lower Limit[/TD]
[TD="align: center"]Time Upper limit[/TD]
[TD="align: center"]Sum of Energy in Range[/TD]
[/TR]
[TR]
[TD="align: center"](min)[/TD]
[TD="align: center"](min)[/TD]
[TD="align: center"](kJ)[/TD]
[/TR]
[TR]
[TD="align: center"]20[/TD]
[TD="align: center"]40[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Thanks,
David

 

[steve the fish]

Pasting your first table into A1 then the result table into D1 try this in F3:

=SUMIFS($B$3:$B$10,$A$3:$A$10,">="&D3,$A$3:$A$10,"<="&E3)

 

[davyj93]

Yes that works perfectly.

Thank you