Hi,

Not sure what to call my situation, but I'll try to explain. I created a
timesheet & want to find out how much time was charged to a particular charge
number, "WITHOUT" calculating the total time - Already have a formula for
this.

Basically, I have a list of charge numbers. Some charge numbers may be
repeated several times.

I have a summary report in which I want to find a particular charge number
from the list. In my summary, I have a column in which I want to
"automatically" find or import the chage numbers being used.

Example:

Available Charge #'s
123
456
789

Charge numbers actually used:
123
456
123


Summary List:

** I would like a formula that recognizes the Available Charge # list,
match the charge numbers being used without double counting, then produce the
results:

I don't have a forumla because I'm not sure what's available or how it may
be work.

Any assistance would be appreciated.

Thanks