Different Sums for Columns based on List Table.

[jbjiii]

Hi All,

I am working on a spread sheet that would show how much I have spent on credit and how much was spent on cash.

In one column the amount that I spent (e.g. $450.00) and the one beside it I have list table drop down CA(for Cash) and CR(for Credit). There will be multiple expenses and I sum the total to show on a dashboard the total amount spent, but I want to add an additional showing the amount that I used in cash and the amount that I used in credit. Any help would be greatly appreciated.

Thank you in advance.

[Pete_UK]

You can use SUMIF, like this:

=SUMIF(sheet1!D:D,"CA",Sheet1!E:E)

assuming your types are in column D of Sheet1 and the amount is in column E of Sheet1. You can have a similar formula for credits - just change "CA" to "CR".

Hope this helps.

Pete

[jbjiii]

Worked great! Thank you

[Pete_UK]

Glad to hear it - thanks for feeding back.

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete