How to sum values in a cell based on information in a drop-down menu.

%3CLINGO-SUB%20id%3D%22lingo-sub-1660680%22%20slang%3D%22en-US%22%3EHow%20to%20sum%20values%20in%20a%20cell%20based%20on%20information%20in%20a%20drop-down%20menu.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1660680%22%20slang%3D%22en-US%22%3EHi%20All%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20just%20wondering%20if%20any%20Excel%20savvy%20people%20could%20tell%20me%20what%20formula%20I%20should%20use%20in%20order%20to%20sum%20the%20values%20of%20a%20cell%20in%20a%20different%20sheet%20based%20on%20information%20from%20a%20drop%20down%20menu.%20Basically%20I%20would%20like%20to%20be%20able%2C%20for%20my%20job%20have%20a%20Month%20to%20date%20figure%20based%20on%20the%20accumulated%20values%20from%20each%20week%2C%20and%20have%20them%20change%20based%20on%20the%20I%20information%20in%20my%20drop%20down%20menu.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1660680%22%20slang%3D%22en-US%22%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-1660968%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20sum%20values%20in%20a%20cell%20based%20on%20information%20in%20a%20drop-down%20menu.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1660968%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F791406%22%20target%3D%22_blank%22%3E%40Aaiken353%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20bit%20abstract.%20Do%20you%20have%20hundreds%20of%20sheets%20and%20their%20number%20is%20variable%2C%20or%20few%20fixed%20number%20of%20sheets.%20What%20is%20the%20logic%20which%20links%20returned%20from%20drop-down%20value%20and%20values%20to%20sum%20-%20by%20position%2C%20by%20ID%2C%20by%20some%20calculations%2C%20etc.%20Is%20it%20one%20number%20from%20each%20sheet%20to%20sum%20or%20ranges%20which%20are%20to%20be%20summed.%20Perhaps%20more%20questions%2C%20but%20better%20to%20have%20small%20sample%20file%20which%20illustrates%20the%20task.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor
Hi All,

I am just wondering if any Excel savvy people could tell me what formula I should use in order to sum the values of a cell in a different sheet based on information from a drop down menu. Basically I would like to be able, for my job have a Month to date figure based on the accumulated values from each week, and have them change based on the I information in my drop down menu.
1 Reply
Highlighted

@Aaiken353 

That's bit abstract. Do you have hundreds of sheets and their number is variable, or few fixed number of sheets. What is the logic which links returned from drop-down value and values to sum - by position, by ID, by some calculations, etc. Is it one number from each sheet to sum or ranges which are to be summed. Perhaps more questions, but better to have small sample file which illustrates the task.