Not sure how I can accomplish this. I am looking for a formula so that if i have Ivonne's name under the agent column on the ACW tab that it will show her total ACD Call and ACW time from the data tab. I tried doing a SUMPRODUCT formula but its not working. I have attached a sample spread sheet. I'm thinking it might need to be a macro but i don't really no anything about those.
Copy of FinalPDR.xls
Hi and welcome to the forum
maybe this...
=SUMIF(Data!A:A,ACW!$A2,Data!C:C)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
and what FDibbins gave you was right and this in col C will give you the time...
=SUMIF(Data!$A:$A,ACW!$A$2,Data!D:D)
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
If you need to be backward compatible
=SUMPRODUCT(--(Data!$A$3:$A$643=ACW!$A2),Data!$C$3:$C$643)
and
=SUMPRODUCT(--(Data!$A$3:$A$643=ACW!$A2),Data!$D$3:$D$643)
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Sumif is already backward compatible..
Forget it.....already answered.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Ummmm, I meant really far back, yeah that's it.
hahaha that made my day, ChemistB
This worked like a charm thanks!
^^^@chemist^^^^
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
CORSTAN21 
Register To Reply
Bookmarks