Forum Discussion

Copper Contributor

Nov 28, 2022

Help with formula's and drop down lists

Hi all, I have 4 categories of which each category has a dropdown list with 3 choices. Once all categories have chosen a number from the drop down list, in a different cell I should be able to s...

excel

Formulas and Functions

Oonar1600

Copper Contributor

Nov 28, 2022

I did my best. Here is a link you can use. I hope it works.
https://we.tl/t-Mq5OjZneax

Jihad Al-Jarady

MCT

Nov 28, 2022

Hi Oonar1600

Use this formula

=SUM(C4+C8+C12+C16)

Oonar1600
Copper Contributor
Nov 28, 2022
Hi Jihad Al-Jarady,

It works and shows as 0 until I start choosing numbers from the drop down menu. As soon as I have chosen those, the formula shoes as #value!
- Jihad Al-Jarady
  MCT
  Nov 28, 2022
  Hi Oonar1600
  
  It is working, check the file attached.
  VALUE.xlsx11 KB
  - Oonar1600
    Copper Contributor
    Nov 28, 2022
    Jihad Al-Jarady oh that's great!
    
    I tried again and it's still not showing up for me. I have attached my screenshot so you can see. I'm not sure what i'm doing differently than you are.