Calculating totals from a certain point in a list

[ExcelRoy]

Hi,

I am looking for a formula to total each line from a certain point in a list

Column G is quantity
Column H is Description
Column I is Price

If there are parts added to the list after it has been done, i need to see what the "additions" would total

So i need a total upto the descrition being "Additions" and a total after the description being "Additions"

Hope this makes sense

Thanks

 

[jasonb75]

Excluding additions

=SUMPRODUCT(--(H2:H20<>"Additions"),G2:G20,I2:I20)

Including additions

=SUMPRODUCT(G2:G20,I2:I20)

Change ranges to match your data.

 

[ExcelRoy]

Thanks Jason,

This doesn't actually do what i needed it to do

Say we begin with 4 lines of £1 each

Then we add for additions 2 lines of £1 each

First Total should be £4
Second Total should be £2

Please bear in mind the position of "Additions" in the decscription can change from line to line for every list

Thanks

 

[jasonb75]

See http://www.mrexcel.com/forum/showthread.php?t=548190

 

[ExcelRoy]

Hi Jason,

Unfortunately my query wasn't answered in that thread?

Thanks

 

[pgc01]

Your question is not clear to me.

If you just want to add items if the description is the string "Additions" you can use Sumif() or Sumproduct().

Maybe if you post some rows of data, the logic and the expected result?

 

[jasonb75]

Hi Jason,

Unfortunately my query wasn't answered in that thread?

Thanks

I wasn't directing you there for a solution, more as a reminder that you already had a thread with the same question.