Thread
:
Sum and Index formula?
View Single Post
#
3
P Sitaram
Posts: n/a
Assuming that you always need a three column offset, try:
=SUM(INDEX(PlanPax,A21,$B$4):INDEX(PlanPax,A21,$B$ 4+3)
Reply With Quote