Timesheets

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

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
--
Ian
--
"Carl Fries" <[email protected]> wrote in message
news:[email protected]...
>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
>

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)


"Carl Fries" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>

Thanks for the feedback. I'll try this out.

Carl


"Bob Phillips" <[email protected]> wrote in message
news:%[email protected]...
> 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)
>
>
> "Carl Fries" <[email protected]> wrote in message
> news:[email protected]...
>> 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
>>
>>
>
>

Thanks for the feedback.

Carl


"Ian" <[email protected]> wrote in message
news:[email protected]...
> 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
> --
> Ian
> --
> "Carl Fries" <[email protected]> wrote in message
> news:[email protected]...
>>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
>>
>
>

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


"Carl Fries" <[email protected]> wrote in message
news:[email protected]...
>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
>