Home

Excel Formula Help

%3CLINGO-SUB%20id%3D%22lingo-sub-448050%22%20slang%3D%22en-US%22%3EExcel%20Formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-448050%22%20slang%3D%22en-US%22%3E%3CP%3ESpreadsheet%20is%20a%20basic%20bookkeeping%20one.%3C%2FP%3E%3CP%3EThere%20are%20cells%20to%20enter%20receipts%20-%20Month%2C%20Day%2C%20Category%2C%20Item%2C%20Amount%3C%2FP%3E%3CP%3ECategory%20is%20a%20predetermined%20list%20of%20expense%20categories.%3C%2FP%3E%3CP%3ETo%20the%20right%20of%20these%20cells%20is%20a%20column%20of%20cells%20listing%20the%20number%20and%20category%20mentioned%20above.%3C%2FP%3E%3CP%3ETo%20the%20right%20of%20that%20is%20a%20month%20grid.%20Jan%20-%20Dec%20along%20the%20top.%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20items%2Freceipts%20are%20entered%20I%20want%20the%20item%20be%20placed%20under%20the%20correct%20month%20and%20along%20the%20correct%20category.%26nbsp%3B%20As%20items%20are%20entered%20the%20Amount%20needs%20to%20be%20added%20to%20any%20amount%20in%20a%20cell%20next%20to%20the%20categories.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EFile%20attached%20-%3C%2FP%3E%3CP%3EJan%201%20receipt%20amount%20should%20be%20listed%20under%20Jan%20column%20next%20to%20category%201%3C%2FP%3E%3CP%3EFeb%202%20receipt%20amount%20should%20be%20listed%20under%20Feb%20column%20next%20to%20category%202%3C%2FP%3E%3CP%3EMar%203%20receipt%20amount%20should%20be%20listed%20under%20Mar%20column%20next%20to%20category%203%3C%2FP%3E%3CP%3EMar%206%20receipt%20amount%20should%20be%20listed%2Fadded%20to%20the%20Mar%20column%20amount%20next%20to%20category%203.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-448050%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-448190%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-448190%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F320324%22%20target%3D%22_blank%22%3E%40dbushn2%3C%2FA%3E%20%2C%20that%20could%20be%3C%2FP%3E%0A%3CPRE%3E%3DSUMIFS(%24E%244%3A%24E%2410%2C%20%20%24A%244%3A%24A%2410%2C%20I%242%2C%20%20%20%24C%244%3A%24C%2410%2C%20%20%20ROW()-ROW(%24G%242))%3C%2FPRE%3E%0A%3CP%3ECustom%20format%20here%20is%3C%2FP%3E%0A%3CPRE%3E%22%24%22%23%2C%23%230.00%3B%3B%22-%22%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
dbushn2
Occasional Visitor

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