i had table that i want to count how many test code "1a and 1b" is greater or equal or less than zero
on my attached file i made a formula using count ifs "how many 1a and 1b test code is greater than zero"it gave me 2 which is wrong it is actually 8
can you solve my problem without using two countifs one for 1 and one for 1b then add them together
counthifs.xlsx
countifs.png
thanks
Bookmarks