Forum Discussion
Solved
Sumproduct partial text on headers. Any way?
This formula =SUMPRODUCT((Data[Match ID]=MatchDashboard)*(Data[Current Player]=Player1Dashboard)*(Data[Top]>0)*(Data[[#Headers],[1BR]:[0BR]]=Data[Top])*(Data[[1BR]:[0BR]]="Top L"))/12 problem si...
rangelsammon I have just added "BR" to your existing formula. Check the attached file and screenshot.
=SUMPRODUCT((Data[Player]="Player2")*(Data[1Area]>0)*(Data[[#Headers],[1BR]:[3BR]]=Data[1Area]&"BR")*(Data[[1BR]:[3BR]]="top left"))
Share a sample Excel file as attachment to your post.
i made an update to the file. i am sorry if it was confusing at first. hopefully i cleared any confusion
rangelsammon I have just added "BR" to your existing formula. Check the attached file and screenshot.
=SUMPRODUCT((Data[Player]="Player2")*(Data[1Area]>0)*(Data[[#Headers],[1BR]:[3BR]]=Data[1Area]&"BR")*(Data[[1BR]:[3BR]]="top left"))Harun24HR lol wth. why didnt i think of that. thank you so much!