![]() ![]() The same function gives me 3 while I want it to give me 2 as an answer since I want to count only A1 and C1. A B Cīut if want to know how many "YES" are in A1 and C1 and ignore whatever B1 has it becomes tricky. ![]() I want to know how many "YES" are in my table, which is easily solved with =COUNTIF(A1:C1,"YES") and it will accurately give me the answer of 3. ![]() I have an excel table were A1 = "YES", B1 = "YES" and C1 = "YES". ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |