Hi guys
I can't seem to think of what formula (combination) is required for the below.
I need to count the number of times that the below has a value in both cells, so for the below this should give me the value of 3 as this is the number of times Subject and Description have a value (entry).
I cant seem to think of what formula to use. I have no issue doing this over one row =COUNT(AND(ISTEXT(A2),ISTEXT(B2))) but am stuck when needing to do this over a range. I did try =COUNTA(AND(ISTEXT(A2:A6),ISTEXT(B2:B6))) but this doesn't seem to give me the outcome needed.
As always thank you for any assistance.
Arts
I can't seem to think of what formula (combination) is required for the below.
I need to count the number of times that the below has a value in both cells, so for the below this should give me the value of 3 as this is the number of times Subject and Description have a value (entry).
I cant seem to think of what formula to use. I have no issue doing this over one row =COUNT(AND(ISTEXT(A2),ISTEXT(B2))) but am stuck when needing to do this over a range. I did try =COUNTA(AND(ISTEXT(A2:A6),ISTEXT(B2:B6))) but this doesn't seem to give me the outcome needed.
As always thank you for any assistance.
Arts