SUMIFS Help Needed!

%3CLINGO-SUB%20id%3D%22lingo-sub-2526597%22%20slang%3D%22en-US%22%3ESUMIFS%20Help%20Needed!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2526597%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELooking%20for%20some%20help%20to%20find%20the%20correct%20formula%20to%20assist%20with%20this%20budget%20sheet%20issue.%20I%20have%20attached%20an%20example%20similar%20to%20the%20one%20I%20am%20trying%20to%20solve.%20I%20am%20looking%20to%20have%20a%20front%20reconciliation%20tab%20that%20auto%20calculates%20the%20total%20expenses%20by%20financial%20quarter%20against%20specific%20accounting%20code%20criteria%20(code1%2C%20code2%2C%20code3%20etc.).%20The%20budget%20is%20managed%20weekly%20(52%20weeks%20in%20total%20across%20a%204%20quarter%20financial%20year)%20-%20please%20note%20the%20attached%20example%20only%20goes%20up%20to%2020%20weeks%20due%20to%20laziness!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-%20Jessica%20(Australia)%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2526597%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2526734%22%20slang%3D%22en-US%22%3ERe%3A%20SUMIFS%20Help%20Needed!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2526734%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1098288%22%20target%3D%22_blank%22%3E%40JessicaBluemouth%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheck%20the%20attached%20WB%2C%20I've%20used%20SUMPRODUCT%20function%20in%20SUMMARY%20Sheet%2C%20and%20it%20gets%20the%20required%20data%20from%20DATA%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3EAdjust%20cell%20references%20in%20the%20formula%20as%20needed.%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20size%3D%222%22%3E%3CSTRONG%3E%3CEM%3E%3CFONT%20color%3D%22%230000FF%22%3E**%26nbsp%3B%20Please%20mark%20my%20post%20as%20Best%20Answer%20as%20well%20Like%2C%20since%20it%20solves%20the%20issue.%3C%2FFONT%3E%3C%2FEM%3E%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi All,

 

Looking for some help to find the correct formula to assist with this budget sheet issue. I have attached an example similar to the one I am trying to solve. I am looking to have a front reconciliation tab that auto calculates the total expenses by financial quarter against specific accounting code criteria (code1, code2, code3 etc.). The budget is managed weekly (52 weeks in total across a 4 quarter financial year) - please note the attached example only goes up to 20 weeks due to laziness! 

 

- Jessica (Australia) 

1 Reply

@JessicaBluemouth 

 

Check the attached WB, I've used SUMPRODUCT function in SUMMARY Sheet, and it gets the required data from DATA sheet.

 

  • Adjust cell references in the formula as needed.

 

**  Please mark my post as Best Answer as well Like, since it solves the issue.