Quick question as im having a brain melt session at work
Simplified version:
I have 2 columns with data in each. lets say both contain a simple YES or NO comment.
I only want to count the number of cells where for example both column A and B contain the variable of Yes. on the same line
Im familiar with for example =countif(A1:A85, "yes") to return the number of cells with 1 argument but want it to only count if its assessing both columns and only counting where both are Yes
I assumed and failed hard that it would be something like: =countif(A1:A85, "yes")And(B1:B85, "yes")
Can anyone help my excel noobishness
Simplified version:
I have 2 columns with data in each. lets say both contain a simple YES or NO comment.
I only want to count the number of cells where for example both column A and B contain the variable of Yes. on the same line
Im familiar with for example =countif(A1:A85, "yes") to return the number of cells with 1 argument but want it to only count if its assessing both columns and only counting where both are Yes
I assumed and failed hard that it would be something like: =countif(A1:A85, "yes")And(B1:B85, "yes")
Can anyone help my excel noobishness