GerryBriant
New Member
- Joined
- Jan 15, 2018
- Messages
- 16
Hi, I am trying to use Countifs to count non blank cells over 2 columns but only count as 1 if adjacent cell is populated ... If that makes sense.
I've tried =COUNTIFS('Sheet1'!$a:$a,"<>",'sheet1'!$B:$B,"<>") to no avail.
For below the answer I'm hoping for is 4.
<tbody>
</tbody>
I've tried =COUNTIFS('Sheet1'!$a:$a,"<>",'sheet1'!$B:$B,"<>") to no avail.

For below the answer I'm hoping for is 4.
Column ‘A’ | Column ‘B’ |
01/01/19 | |
| 01/01/19 |
01/01/19 | |
| |
01/01/19 | 01/01/19 |
<tbody>
</tbody>