Help me write a formula to add all values in column B with a given marker in another corresponding column
Hi, I'm looking for a formula to help me do something very specific. I am not very well versed in advanced Excel language, but what I"m trying to do seems relatively simple. I have large finance tracking spreadsheet. I have the date in Column A, expenditure name in Column B, the amount spent in Column C and who of two ppl spent the money on that purchase initialed in Column D. What I want then is total the amount spent by person with initial J for the month and total the amount spent by person H for the month. So in Cell G40, I would want sum of all values in column C where there is the letter J in Column D. And in H 40 I want all values in Column C for which there is an H in Column D. Please let me know if this doesn't make sense.
Thanks for your help!
create a pivot table of your
create a pivot table of your data.
http://excelexperts.com/Teach-Yourself-Excel-Lesson-25-Create-A-Pivot-Table