How to have value belonging to category from lookup excluded in calculation

A

AA Arens

I have a Task Account

I use lookup feature with a category list on a separate sheet. OK, so
far.
Right of the category drop down list I have drop down list to choose
amount hours. The hours are then totalized. How to have not the value
totalized when a certain category is choosen?

Sample:

CATORY: HRS:
Finance 3
Sales 5
Off 2
Training 1

TOTAL 9 as OFF is not included.

Bart
Excel2003
 

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

return one value from list 2
match value within any portion of lookup string in range 3
how to lookup a value in a list and return multiple corresponding 2
How can I get a value from one drop down list to another in excel 4
how to lookup value in a form 1
Filling in value of field from other table based on previous field entry 1
How to return value from functions in other sheets? 3
How To Get 1 Million Visitors Without Paying A Dime In Advertising 0

Top