To count the Empty cells in a row

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.

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

Loop through it

Set counter = 0

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

1 Like

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 ?
1 Like

Hey, thank you y’ll

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.