What kind of formula/s would be needed to select specific catagories and sum relavent numbers to a different cell

Creating an expense form. Need to sum numbers for subtotal, taxes, total according to type of Goods Purchased. What kind of formulas could be used to search criteria + sum numbers for Admin Use. Attached File...

Mitch

AttachmentSize
Expense report draft format.xlsx19.64 KB

Why not use a Pivot Table??

Personally I would use a pivot table for this as it is friendlier to edit as your needs may change in the future.

However if you do wish to use a formula paste the following into cell J26 and copy accross and down to N31

=SUMPRODUCT(($F$7:$F$18=$I26)*(J$7:J$18))

Regards
Mark