SOLVED

Help with using multiple drop-down lists with SUMIFs functions

%3CLINGO-SUB%20id%3D%22lingo-sub-1789182%22%20slang%3D%22en-US%22%3EHelp%20with%20using%20multiple%20drop-down%20lists%20with%20SUMIFs%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1789182%22%20slang%3D%22en-US%22%3E%3CP%3EOk%20here%20is%20what%20I'm%20trying%20to%20do.%20If%20anyone%20could%20help%20asap%20I%20would%20greatly%20appreciate%20it.%3C%2FP%3E%3CP%3EI%20have%202%20columns%20with%20data%20validation%20lists%20(drop-downs)%20and%201%20column%20with%20numbers.%3C%2FP%3E%3CP%3EI%20want%20the%20user%20to%20choose%20an%20item%20in%20the%20drop-down%20(column%201)%20and%20drop-down%20(column%202).%3C%2FP%3E%3CP%3EDepending%20upon%20the%20combination%20of%20what%20the%20user%20chooses%20in%20dropdown%201%20and%202%2C%20it%20would%20SUM%20up%20the%20corresponding%20number%20in%20the%203rd%20column.%3C%2FP%3E%3CP%3EI%20hope%20this%20makes%20since.%20I%20tried%20to%20upload%20an%20image%20of%20what%20I'm%20doing%2C%20but%20it%20kept%20freezing%20on%20me.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3ERegina%3C%2FP%3E%3CP%3EI%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1789182%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1790634%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20using%20multiple%20drop-down%20lists%20with%20SUMIFs%20functions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1790634%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F834328%22%20target%3D%22_blank%22%3E%40rneal%3C%2FA%3E%2C%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20example%20below%2C%20cell%20E1%20and%20F1%20have%20data%20validations.%20Cell%20G1%20is%20the%20sum%20of%20both%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DSUM(E1%2BF1)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Bennadeau_0-1602876328388.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F227227i8B946E014E83ED73%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Bennadeau_0-1602876328388.png%22%20alt%3D%22Bennadeau_0-1602876328388.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EIs%20that%20what%20you%20wanted%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Ok here is what I'm trying to do. If anyone could help asap I would greatly appreciate it.

I have 2 columns with data validation lists (drop-downs) and 1 column with numbers.

I want the user to choose an item in the drop-down (column 1) and drop-down (column 2).

Depending upon the combination of what the user chooses in dropdown 1 and 2, it would SUM up the corresponding number in the 3rd column.

I hope this makes since. I tried to upload an image of what I'm doing, but it kept freezing on me.

 

Thanks,

Regina

I

5 Replies

Hi @rneal,  

In the example below, cell E1 and F1 have data validations. Cell G1 is the sum of both:

=SUM(E1+F1)

 

Bennadeau_0-1602876328388.png

Is that what you wanted?

 

No. It's two columns with a data validation drop-down and one column with data. It's a conditional, probably sumifs function; but I couldn't get it to work.

@rneal 

Can you upload an example in a spreadsheet or at least try again with the screenshot. I'm not sure I understand the issue.

@Bennadeau  I will try to upload again.

Best Response confirmed by rneal (New Contributor)
Solution

Hi @rneal,

 

See attached. I fixed your typos in the drop down list. 

I believe this is what you want but I'm not sure how you want to populate the numbers in "Number of participant" (E15 to E24). What is it based on? Anyways, I added some fictitious numbers to test "row 2".