Quote:
Originally Posted by Mazzaropi
Dear Bretai2k, Good Evening.
I´m sorry!
As my Excel is in Portuguese the sheet here is called Plan.
I forgot to change this for you.
Try this one now.
=SUM(INDIRECT(CONCATENATE("Sheet2!$B",MATCH(A2,She et2!$B$2:$B$75,0)+1,":$B",MATCH(B2,Sheet2!$B$2:$B$ 75, 0)+1)))
Have a nice day.
|
Thank you so much for your help thus far. I'm still getting #N/A when it gets to the Sheet2! portion of each Match function. The actual range of cells I want to validate against is on Sheet1, cells B2 through B75, while the function is checking the start and end of the range on sheet 2, cells A2 and B2.
Similar Threads
Threaded Mode
