multiple options

  1. D

    Using IF AND and COUNTIF in one formula

    I have 6 dropdowns with the same 30+ options to choose from in each. 10 of those options have similar attributes and I want to advise the user if they pick 4 out of 6 of these when filling in the 6 dropdowns. I have a cell off to the side of these options that will display this message. I got...
    • Dmerritt16
    • Thread
    • and and or function countif dropdown if funcitons multiple options
    • Replies: 3
    • Forum: Excel Questions
  2. D

    Sumproduct for more than one option

    Afternoon all I have a Sumproduct formula that is =SUMPRODUCT(--(Sheet1!I4:I1000="yes"),--(Sheet1!AA4:AA1000="other")) This seems to work fine so I was happy with that. What I would like to do is have the bit looking for "other" to also look for "participate". So it will count those that...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top