Hi guys
Basically I have a data set like below picture shown, and I am trying to create a dashboard where if I enter the starting week and ending week dates (highlighted in yellow) then I will get the sum of each client's number within the time period of the data set.
Sorry if I am not being clear and please let me know if you need any clarifications. Thank you!
111.PNG
Last edited by JJPP; 07-06-2023 at 12:13 AM.
Take a look at using sumifS() for this
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
VLOOKUP cannot meet this requirement, only SUMPRODUCT can.
Since the image does not display the row and column addresses, I assume the following in the dataset:
Client list: A3:A5
Weeks: B2:F2
Value range: B3:F5
Starting week: B8, End week: D8
With ClientA in A10, B10 will be:
=200
Please Login or Register to view this content.
Quang PT
This is perfect! Thank you so much!1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks