L Lasantha Member Aug 26, 2019 #1 Dear All, Kindly look into the attached details. could you please give me a formula to get count of "J" column which contains "Less Hours" . Thank you for your time. Lasantha. Attachments count Less Hours.xlsx 10.1 KB · Views: 5
Dear All, Kindly look into the attached details. could you please give me a formula to get count of "J" column which contains "Less Hours" . Thank you for your time. Lasantha.
L Lasantha Member Aug 26, 2019 #3 bosco_yip said: Perhaps, =COUNTIF(J2:J18,"Less Hours*") Regards Bosco Click to expand... thank you