Using a Formula to add up totals of similar Value

[Zeus82]

Hello all,

I have a basic spreadsheet which I use to keep a tally of garage sales.

I would ideally like to have a formula that would automatically add the value of all MOT sales and update as a new MOT bill is added even if the cost varies.

Would this be a =SUMIF formula and how would I get it to only tally up the costs that are MOT costs?

I have added a basic version of the spreadsheet below to give you a better idea?

Thanks in advance

Zeus82

[Pete_UK]

You can use this formula in cell K8:

=SUMIF(E8:E13,"MOT",G8:G13)

Hope this helps.

Pete

[Zeus82]

Hi Pete,

That's perfect!!

Thank you so much for your help!!

Zeus82