Oct 09 2019 10:34 AM
Oct 09 2019 10:46 AM
Hi @Gill_4711
You can achieve this by using Countif() function:
=COUNTIF(B3:F3,"1")
A sample file is also attached for your reference, please let me know if it works for you.
Thanks
Tauqeer
Oct 09 2019 02:30 PM