SOLVED
Home

Pull a total based on two criteria

%3CLINGO-SUB%20id%3D%22lingo-sub-891092%22%20slang%3D%22en-US%22%3EPull%20a%20total%20based%20on%20two%20criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-891092%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20been%20trying%20to%20setup%20a%20bill%20splitting%20sheet%20based%20on%20two%20criteria%3A%20the%20name%20of%20who%20bought%20say...%20groceries%2C%20and%20the%20month%20it%20was%20purchased.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20did%20identify%20one%20issue%20I%20was%20having%20and%20fixed%20it%20(Access%20was%20formatting%20my%20month%20cells%20as%20text%20instead%20of%20a%20date%2C%20which%20I%20have%20fixed)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'd%20like%20to%20avoid%20using%20helper%20cells%20if%20at%20all%20possible%20since%20I%20want%20to%20let%20my%20data%20auto%20populate%20from%20access%2C%20and%20that%20would%20require%20a%20lot%20of%20unnecessary%20formulas%20that%20would%20slow%20excel%20down%20or%20a%20lot%20more%20manual%20editing%20which%20would%20make%20it%20useless%20anyway.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20can%20get%20the%20total%20bought%20for%20the%20month%20to%20auto%20populate%20into%20the%20red%20cell%20on%20sheet%201%2C%20I%20have%20formulas%20setup%20to%20figure%20out%20how%20much%20everyone%20owes%20each%20other.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E(I%20am%20using%20the%20insider%20build%20of%20365%2C%20so%20I%20have%20access%20to%20xlookup%2C%20filter%2C%20etc.%20if%20that%20helps)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance!%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-891092%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-892205%22%20slang%3D%22en-US%22%3ERe%3A%20Pull%20a%20total%20based%20on%20two%20criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-892205%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F419419%22%20target%3D%22_blank%22%3E%40NekoTehKat%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20should%20check%20out%20the%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fsumifs-function-c9e748f5-7ea7-455d-9406-611cebce642b%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ESUMIFS%3C%2FA%3E%20function.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-893022%22%20slang%3D%22en-US%22%3ERe%3A%20Pull%20a%20total%20based%20on%20two%20criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-893022%22%20slang%3D%22en-US%22%3EThis%20works%20wonderfully!%20Thank%20you!%20%3CLI-EMOJI%20id%3D%22lia_red-heart%22%20title%3D%22%3Ared_heart%3A%22%3E%3C%2FLI-EMOJI%3E%20(I%20kept%20trying%20to%20use%20a%20nested%20vlookup%20and%20a%20couple%20other%20things)%3C%2FLINGO-BODY%3E
NekoTehKat
New Contributor

I've been trying to setup a bill splitting sheet based on two criteria: the name of who bought say... groceries, and the month it was purchased.

 

I did identify one issue I was having and fixed it (Access was formatting my month cells as text instead of a date, which I have fixed)

 

I'd like to avoid using helper cells if at all possible since I want to let my data auto populate from access, and that would require a lot of unnecessary formulas that would slow excel down or a lot more manual editing which would make it useless anyway.

 

If I can get the total bought for the month to auto populate into the red cell on sheet 1, I have formulas setup to figure out how much everyone owes each other.

 

(I am using the insider build of 365, so I have access to xlookup, filter, etc. if that helps)

 

Thank you in advance!

 

 

2 Replies
Solution

@NekoTehKat 

You should check out the SUMIFS function.

This works wonderfully! Thank you! (I kept trying to use a nested vlookup and a couple other things)
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies