paun_shotts
New Member
- Joined
- Nov 4, 2021
- Messages
- 38
- Office Version
- 2013
- Platform
- Windows
Hi,
This is probably really simple, but I am not able to get my head around it.
In the attached screenshot, I have a sheet of around 600 entries, I want to count the number of empty cells in column J, where column A is not blank (greater than 0)
I will be placing the formula on a new sheet, referencing the sheet below is called "2022"
Thank you in advance.
This is probably really simple, but I am not able to get my head around it.
In the attached screenshot, I have a sheet of around 600 entries, I want to count the number of empty cells in column J, where column A is not blank (greater than 0)
I will be placing the formula on a new sheet, referencing the sheet below is called "2022"
Thank you in advance.