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
Attachment | Size |
---|---|
Expense report draft format.xlsx | 19.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