Forum Discussion
dbushn2
Apr 12, 2019Copper Contributor
Excel Formula Help
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 i...
SergeiBaklan
Apr 12, 2019Diamond Contributor
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;;"-"