how to use COUNTM with exceptions
Can someone please help me on the below formula?
I am using this formula to get the total tasks in column Total Task but I don't want to consider Hours element so if we select other elements along with the Hours the total should be counting all the other elements + number of addtional task except the Hours element.
=COUNTM([Task Type]@row) + ([Additional Task]@row)
Help Article Resources
Check out the Formula Handbook template!