I have the following SUMPRODUCT formula: =SUMPRODUCT(((A2:A11=X1)*(B1:K1<=X2))*B2:K11)
How would you re-formulate this formula to use it across different sheets? For instance, Sheet 1 to 4.
I am a little bit familliar with the INDIRECT fuction but I wasn't able to solve it so far.
Would appreciate any help.
Thank you.
You get better help on your question if you add a small excel file, without confidential information.
Please also add manualy the expected result in your file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks