Formula to calculate totals depending on Drop Down Menu

Hey All,

I am an excel newbie and was hoping one of you could please help me with my spreadsheet?

I have an expense report that our employees use to tabulate all their expenses both on company credit card and out of pocket. What I am hoping to do is for the spreadsheet to calculate how much is out of pocket and how much is on the company credit card depending on whether they choose one of the two from the drop down menu? Also to be added to the formula is the amount we owe them in Per Diems from colum D50

I want the totals to show at J40 for out of pocket (including the per diem D50)
and J41 for the credit card

I really look forward to hearing from you

Kind Regards
Heather Norris

You want something like:

=SUMIF(G7:G37,"Amex",C7:C37)

to get the credit card total, and:

=SUMIF(G7:G37,"Out of pocket",C7:C37) + D50

for the other expenses.

Hope this helps.

Pete

Thank you both for your prompt responses! Expense report is now done

Cheers
Heather