Quote:
Originally Posted by Bretai2k
I have 2 dropdowns (A2 and B2) on sheet 1 that both reference cells B2 through B75 on sheet 2. I want to be able to do a SUM of all cells in the B column of sheet 2 between what I select in dropdowns A2 and B2.
I can provide examples if this is not clear enough.
TIA
|
<<<<<
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.