Looking for Help / Guidance
Looking to do something extremely simple but just cannot get it done. Hoping that the folks in this community can assist.
I have 2 sheets. See below.
All I am trying to do is .. in Sheet A ...
Value of License Used for Customer Number (1234) be the Sum of all the same Customer Number ("1234") where "Used (Y/N)=Y". IN short in "Sheet A" Customer Number "1234" should show a value of 4 for column "License Used".
Similarly Customer Number 1567 should have 5 for "License Used"
Similarly Customer Number 9654 should have 3 for "License Used"
I tried countifs but keep on running into syntax issues. I come from excel world and the lack of pivot tables in SmartSheets is making me try other tricks. Any guidance is appreciated.
Help Article Resources
Check out the Formula Handbook template!