data validation, totaling values based off dropdown lists
I need add the total number of hours for only those patients
who have a specific text item selected in the first dropdown list.
Column B = drop down list of injuries
Column C = drop down list of hours
=SUMPRODUCT(--(B1:B10="injury"),C1:C10)
Replace injury with the actual injury: fracture, laceration, sprain,
whatever.
Better to use a cell to hold the criteria:
E1 = fracture
=SUMPRODUCT(--(B1:B10=E1),C1:C10)
--
Biff
Microsoft Excel MVP
"Jesse Blanchard" wrote in
message ...
The situation: I have a list of patient names in one column, a dropdown
list
with four text options (for their type of injury) in another, and another
dropdown list with a numerical value of how many administrative hours
spent
on them in another dropdown list.
I need a formula that will keep tally of the number of hours spent on a
patient according to their injury. So, in short, I need add the total
number
of hours for only those patients who have a specific text item selected in
the first dropdown list.
Thanks to all who reply to these things. I have learned a lot about excel
in
just two days thanks to your help.
|