I have a worksheet with a year's expenses listed.
Col A=Date
Col B=Vendor, say (Jack's Gulf Station), etc.
Col C=Category of expense
Col D=Amount of expense
Col E=Running Total
What I would like to have is section off to the side which would be used to show how much money was spent with each of the named in column B, such as say (Jack's Gulf Station), for the entire year.
I would use Column F for the Vendor, and column G for the amount or the year's total for that particular vendor.
What formula should I use to accomplish this?
Thank you for your help.
Bookmarks