Timesheets

C

Carl Fries

I am developing a timesheet with a set of standard tasks in a drop down
list. Some of those tasks can be capitalized, some can not. I want a way
to be able to only total up the hours for the capitalized tasks. Can anyone
give me an idea of how to do this?

Thanks,
Carl
 
B

Bob Phillips

Maybe something like

=SUMPRODUCT(--(A2:A20=PROPER(A2:A20)),B2:B20)

where A is the tasks, B the time

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
C

Carl Fries

Thanks for the feedback.

Carl


Ian said:
You can do it with another column.
Assume task is in A1 and time is in B1. In C1:

=IF(EXACT(A1,UPPER(A1)),B1,"")

The SUM column C
Click to expand...
 
C

Carl Fries

Has anyone ever used the VLOOKUP function for this or something similar? I
am not familar with this function. Any idea how I would configure it to
perform this function?

Thanks in advance for your help.

Carl
 
Top