I need help with creating a formula to pull data from a table...
HELP1.JPG
HELP2.JPG
I am looking for some help. I want to be able to formulate the second attachment table so that it will auto populate the calls handled amount by the team name and date. I hope that made sense.
I'm trying to wrap my head around it and for some reason (I don't know why, maybe I've been working too long) it just won't calculate in my head.
I'm looking for the formula that will help.
Thank you,
You need SUMIFS:
=SUMIFS($D2:$D5,$C2:$C5,T2!$A2,$B2:$B5,T2!B$1)
where T2 refers to the bottom table.
Sad to note that you didn't have the courtesy to respond to any of the help offered to you in your previous thread.
Last edited by AliGW; 08-22-2019 at 12:52 PM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
I forgot I even had access to this amazing forum until today. And then I found my previous post and can't believe I forgot about it
It's never too late to say "thanks".
Anyway, did my suggested solution here help you at all?
Yes it did. Thank you very much
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks