sum conditional

J

JOE RR

Alright. I'm trying to sum data entered into cells based on the drop down
selection of another cell.

Cells B6, B16, B26, and B36 have drop down lists. Depending on the
selection in any one of these drop down cells, corresponding subprocesses are
filled in cells b7:b14, b17:b24, and so on.

Data is then entered in cells c7:c14, c17:24, and so on, based upon the
selection that has been made in each of the drop down lists.

I want to SUM the data of a specific cell in each data range in a summary
cell at the bottom of the worksheet.


Example

Cell B6: drop down option 1 is selected
Data is entered in c7

Cell B16: drop down option 2 is selected
Data is entered in c17

Cell B26: drop down option 1 is selected
Data is entered in c27

Cell B36: drop down option 2 is selected
Data is entered in c37

How would I sum up the data entered in cells according to the drop down
selection that has been chosen? (Keeping in mind that multiple drop down
options may be selected on a single worksheet).
 
B

Bernard Liengme

This will sum the C cells when the corresponding B cells equal 1:
=C7*(B6=1)+C17*(B16=1)+C27*(B26=1)+C37*(B36=1)
I think you can see how to get the result for 2
best wishes
 
B

Bernard Liengme

I tested the formula before posting. So you need to check that there are
really numbers in the cells.
Try =ISNUMBER(C7) and ISNUMBER(B6)
If the test values are not really numbers use:
=C7*(B6="1")+C17*(B16="1")+C27*(B26="1")+C37*(B36="1")
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top