data valiation, dropdown list question

  • Thread starter Thread starter Jesse Blanchard
  • Start date Start date
J

Jesse Blanchard

I'm creating a document for a hospital that keeps track of different types of
patients and tallys each time an option from the drop downlist is selected.
There are two different dropdown lists for each patient. What I need to know
is if its possible to create a conditional statement so that a patient is
counted only if the two drop down lists meet a specific combination. Thanks.
 
Assume drop downs are in A1:A10 and B1:B10

=SUMPRODUCT(--(A1:A10="condition1"),--(B1:B10="condition2"))

If the conditions are *text* enclose them in quotes as above. If the
conditions are numeric values *do not enclose them in quotes*.
 
Yes, it is. What constitutes "a patient is counted"? What are the options
is each dropdown list and what are the "specific" combinations? HTH Otto
 

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

Similar Threads

data validation, totaling values based off dropdown lists 5
Data Validation, drop list question 1
help with averages formula 2
dropdown lists and populating new table based on the selection 3
How do you link drop down lists in excel? 1
Restating question regarding conditional sum from multiple columns 2
Data Validation, Drop Down Lists 1
Conditional List dropdowns? 1

Back
Top