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

You should reply to my response (stay) in your original thread. That's the
way to have great discussions going in the newsgroups. I gave you an
index/match suggestion in your earlier posting, with customary details on
the sheets' set-up assumptions made. Didn't that work for you?

You could also upload your sample file/data using a free filehost, then post
a link to it here.

Eg, you could use this free filehost to upload:
http://www.freefilehosting.net/

Copy the "direct link" which is generated after you upload,
then paste it here
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jason" wrote in message
...
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