I don't think it can be done with SUMPRODUCT, I think you're going to end up needing an array solution.
Can you post an example spreadsheet to work with?
I don't think it can be done with SUMPRODUCT, I think you're going to end up needing an array solution.
Can you post an example spreadsheet to work with?
Click the [* Add Reputation] Button to thank people for help!
Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks