Sum groups of values

[danturv]

Hi

I have a sheet to tally purchase orders with different numbers of items on them and would like to add a total for each PO. Not sure how to achieve this so any help would be appreciated. Essentially I need to SUM all sub totals for each PO ref. as shown in the attachment

Thanks in advance for any help offered

[DBY]

Hello
Maybe the following formula in F2 copied down:

Please Login or Register  to view this content.

Hope this helps.
DBY

[danturv]

Spot on, thanks very much