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 sits in the bold above.
in Column Top there is numbers 1 through 10.
i want the headers 1BR through 0BR (1 to 10) if match the number in the Top column to continue. everything works but i cant get this part of the function to calculate.
any help is greatly appreciated!
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"))
5 Replies
- 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"))
- Thank you Harun24HR.
https://1drv.ms/x/s!AnFi6uGE1rekixqrlwReC9l3XRwU?e=q5sV10
