View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Corkey Corkey is offline
external usenet poster
 
Posts: 11
Default Long formulas for totals

In another pickle and need some help if you please.

Have columns for our HR to track vacation, personal, holiday, etc. Since
each day could be a different code, can someone help me with the if, else
formula. Cant seem to get what I need. Can get it for one cell but not the
rest.

Example:

Code hours
H 8.00
V 5.00
S 3.00

Total H
Total V
Total S

Want the formula to be if code = H than add hours to Total H, if code = V,
add to total value V, and so on.

I have all the rest automated but am stuck in this pickle€¦. Help€¦€¦€¦ Thanks
everyone!