Forum Discussion

rangelsammon's avatar
rangelsammon
Brass Contributor
Sep 01, 2022
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...
excel
Formulas and Functions
  • Harun24HR's avatar
    Harun24HR
    Sep 01, 2022

    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's avatar
Harun24HR
Silver Contributor
Sep 01, 2022
Share a sample Excel file as attachment to your post.
rangelsammon's avatar
rangelsammon
Brass Contributor
Sep 01, 2022
Thank you Harun24HR.
https://1drv.ms/x/s!AnFi6uGE1rekixqrlwReC9l3XRwU?e=q5sV10