I am aware that I may be asking the wrong question here. Not sure how to ask, but I am trying to create a budget on google sheets that to record how much I spend on each day. Right now I have the transaction shown below:
Date | Category | Amount
--------------------------
Jan 1| Dining | $5
Jan 1| Dining | $30
Jan 1| Gas | $20
Jan 2| Other | $15
I want to know how I could use the information I have above to create the table shown below:
Date | Dining| Gas| Other
------------------------
Jan 1| $35 | $20| $0
Jan 2| $0 | $0 | $15
I'm stuck trying to use a LOOKUP and SUMIF together.