To count the Empty cells in a row

[Ray_Sha1 (Ray Sha)]

Hi all,

I have a excel sheet with range A1:Y18
I have to check if the empty cells is present in column R,S,T
And write the count in the next cell Z.

Any idea how to achieve this?

Thanks in advance.

[AndyMenon]

There are multiple ways to do it.
Easiest is to read the excel sheet into the DataTable

Loop through it

Set counter = 0

check
if row(“R”) or row(“S”) or row(“T”) is null or empty using a series of if statement for each condition.
If each cell is empty, then add 1 to counter
Then write it row(“Z”) = counter

[Hiba_B (Hiba Beldi)]

Hi @Ray_Sha1 !
Here is a suggestion: count_empty_cells.xaml (9.2 KB)
Don’t forget to modify your read and write range.
Also, let me explain some elements:

• In the variables, I translated R,S and T at their equivalent numbers
• I used read range from A1 to Z18 because from my understanding you want to paste the result at the same line but in the cell Z. Did I understand correctly ? Or do you want the result to be seen at the same line but in the cell AA, or did you want the result to appear at the cell Z but in the nex line ?

[Ray_Sha1 (Ray Sha)]

Hey, thank you y’ll