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

  • Thread starter Thread starter AA Arens
  • Start date Start date
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

Trying to create calculation based on a grouping of categories 6
Display 0 in a textbox that obtains a null value from a subform 6
return one value from list 2
Calculating values in reports. 3
Calculating Categories relating to Financial info 1
Calculate leave time in a query 4
How to create a formula that results in a blank cell if required 7
How do I create a lookup using layered parameters 2

Back
Top