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.

Sheet A:

Sheet B:

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.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!