Hi, in the attachment, I'm wondering how to take values in the top table, sum them up only if they're in the "X" rows, and then return the sum of all the numbers by month in the bottom table.
Example:
For part # B, I want to output the sum of 30+31+30+31 = 122 and put the result in the column for February for Part B.
It seems like a simple concept, and I've tried vlookups, sumifs, and sumproducts with criteria, but I can't figure out how to make it work.
Thank you guys so much!
Any chance you'd consider posting your workbook instead of a screenshot? I have a pretty good idea of how to go about it, but I'd like to play with the data rather than reconstruct it...
If your question has been satisfactorily addressed, please consider marking it solved. Click the Thread Tools dropdown and select Mark thread as solved.
Also, you might want to add to the user's reputation by clicking the star icon in the lower left corner of the post with the answer- it's why we do what we do...
Thomas Lafferty
Analyst/Programmer
Hello,
See the attached. You can define dynamic named range with relative reference to reduce the length of the formula.
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
Thank you!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks