Forum Discussion

Abe_Ryker's avatar
Abe_Ryker
Copper Contributor
May 16, 2019
Solved

Creating a Complex Points-Calendar System

Hi! I want to create a point-calendar system for a schedule that I'm creating for my team. I'm new to excel, and my many google searches led me to be more confused. Here's what I'm trying to create:...
excel
Formulas and Functions
  • Twifoo's avatar
    Twifoo
    May 16, 2019

    Abe_Ryker 

    I have modified the layout of your data. In the attached file, the formula in B4, copied down rows, is: 

    =SUMPRODUCT((B$13:H$17=A4)*B$11:H$11)

Twifoo's avatar
Twifoo
Silver Contributor
May 16, 2019

Abe_Ryker 

I have modified the layout of your data. In the attached file, the formula in B4, copied down rows, is: 

=SUMPRODUCT((B$13:H$17=A4)*B$11:H$11)

  • PeterBartholomew1's avatar
    PeterBartholomew1
    Silver Contributor
    May 17, 2019

    Twifoo 

    Transposing the points table simplifies both the formula and the UI design!

  • Abe_Ryker's avatar
    Abe_Ryker
    Copper Contributor
    May 16, 2019

    Twifoo 

    Wow! This is exactly what I was looking for. Thank you so much!

    • Twifoo's avatar
      Twifoo
      Silver Contributor
      May 16, 2019
      You’re very much welcome!

Resources