Here's what I need:
I have a speadsheet with a tab named "Stores" where quantities are entered into Column B. Then in Column D the day of the week is entered. I need to get the sum from Column B in the "Stores" Tab put into "Summary" Tab based on the day entered in Column D on the Processed Tab.
Normally I can muttle through and figure this out..but my brain isn't cooperating right now. Sure would be greatful if someone can help me out.
I've attached an example.
Thanks in advance for the help.
I put formulas in Mon, Tues, Wed...and I thought I'd let you fill in the rest, if that's okay....HTH
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
Hi and welcome to the forum
# of Stores...=COUNTIFS(Stores!$A$2:$A$23,"<>",Stores!$D$2:$D$23,LEFT(C$2,IF(C$2="Thursday",2,1)))
Units...=SUMIFS(Stores!$B$2:$B$23,Stores!$A$2:$A$23,"<>",Stores!$D$2:$D$23,LEFT(C$2,IF(C$2="Thursday",2,1)))
Cartons...=SUMIFS(Stores!$C$2:$C$23,Stores!$A$2:$A$23,"<>",Stores!$D$2:$D$23,LEFT(C$2,IF(C$2="Thursday",2,1)))
all copied across
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
Thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks