Formula for adding when cell is based on drop down choice

A

Angel

I am trying to modify a timesheet that has been created already. I have
added a dropdown list of codes next to each day and projects time so it can
be billed properly to the work done. Isn't there a formula to add if column b
cell = 17 then add corresponding column a cell. I hope I have worded this
correctly so someone understands what I am talking about.
Project Name 6/20/09 Code 6/21/09 Code 6/22/09 Code
Jamesville 8 17 6 14 9 12
Mission 6 10 8 17 5 14
 

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

Putting a formula in place one time for the entire spreadsheet 2
Evaluating Week No. 8
Calculating values to column D with formula based on values column A 1
Compare cells 1
Delete some rows at the end of the file 2
Conditional Formatting using VBA 5
Calculating actual login hrs in excel using macro or formula 1
Return value of heading if an adjacent cell in a row is not blank 3

Top