Quote:
Originally Posted by Mazzaropi
<<<<< HELP from BRAZIL
Dear Bretai2k, Good Afternoon.
Take a look at it and tell me if it worked for you.
=SUM(INDIRECT(CONCATENATE("Plan2!$B",MATCH(A2,Plan 2!$B$2:$B$75,0)+1,":$B",MATCH(B2,Plan2!$B$2:$B$75, 0)+1)))
Fell free to ask anything about your question.
Have a nice day.
|
Concatenate might be what I am looking for, but I'm trying to understand what the Plan2 are referencing. When I plug it in, it asks me to update values and then I get #N/A? for the two Plan2s that are referenced after the MATCH function.