Apr 12 2019 01:43 PM
Spreadsheet is a basic bookkeeping one.
There are cells to enter receipts - Month, Day, Category, Item, Amount
Category is a predetermined list of expense categories.
To the right of these cells is a column of cells listing the number and category mentioned above.
To the right of that is a month grid. Jan - Dec along the top.
As items/receipts are entered I want the item be placed under the correct month and along the correct category. As items are entered the Amount needs to be added to any amount in a cell next to the categories.
File attached -
Jan 1 receipt amount should be listed under Jan column next to category 1
Feb 2 receipt amount should be listed under Feb column next to category 2
Mar 3 receipt amount should be listed under Mar column next to category 3
Mar 6 receipt amount should be listed/added to the Mar column amount next to category 3.
Apr 12 2019 01:59 PM
@dbushn2 , that could be
=SUMIFS($E$4:$E$10, $A$4:$A$10, I$2, $C$4:$C$10, ROW()-ROW($G$2))
Custom format here is
"$"#,##0.00;;"-"