Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
SumIf based on two criteria
I currently have a sheet. It tracks my finances. It is setup such that:
A: Establishment where I bought something B: Date C: Category of Purchase D: Amount of Purchase E: Memo Field F: Tender (Cash, Check, Credit Card, etc.) G: Day of the Week purchase was made Right now, I use a sum if to Sum Column D Dependent on Tender. I will be getting married before the end of the year (and discussions of that aside), I want to know how to Do a SumIf on the Amount category that is based both on the Tender and on who spent it (which will be a new column H). So I would have: Mark Anne Cash total total Check total total Credit Card 1 total total with each of those totals being computed based on cash and the name of the person who spent it. If anyone knows how to do this, I'd appreciate the input. Thanks, Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use the sumif if I have multiple criteria (i.e. greater . | Excel Worksheet Functions | |||
SUMIF in multiple columns based on other criteria in Excel? | Excel Discussion (Misc queries) | |||
Is it possible to use the sumif function based on the criteria of. | Excel Worksheet Functions | |||
"criteria" in a sumif refering to the value in another cell | Excel Discussion (Misc queries) | |||
Can I use a cell reference in the criteria for the sumif function. | Excel Worksheet Functions |