Forum Discussion
Abe_Ryker
May 16, 2019Copper Contributor
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:...
- May 16, 2019
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)