I have an issue where I'm trying to summarize customer data by product. The data I receive (sheet 1) contains the product, metric and customer by month. I need to summarize this data using data validation, allowing for the month and metric (in this example Sales $ and quantity) to be changed by the user. This screams of a sumif formula but the column to look up will change based on the selected month. I'm unsure how to make a formula work and was hoping for a hint or two from you experts.
i have the sum function for you, still working on the count function (see attached).
will each month always have an entry in each row? in other words, with the count of each month always bee the same?
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
Thank you for replying. Is there any chance you'd attached the wrong "book 1" file? Attached isn't the data or format of my original attachment. To answer your question, yes each month will always have an entry in each row.
lol yes it is possible. many posters call their file book1, example1 etc. try this 1, sorry
if all months will have entries, then the count part of it is easier than i thought.
Ha! Can you please attach the file so I can take a look? (are you sure you're not just messing with me?)
i missed attaching it the 1st time, sorry) but edited my post and attached it....and nope im not messing with you, its just my fingers working slower than my brain lol
Thanks so much for your help. I believe this offset/match method will help me tons moving forward. Have a great one!
-Joe
you'r welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks