Excel Formula Help

Copper Contributor

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.

 

 

 

1 Reply

@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;;"-"