COUNTA/array

[Remster]

Hi Folks

Please see the image below, which is a simplification of my spreadsheet (there are in fact a few more columns and many more rows). I'm trying to come up with a single formula in E6 that counts the number of rows that contain at least one non-blank cell, so in the current example the value in E6 would be 3. I'm sure this has something to do with COUNTA and arrays, but I can't get my head round it.

Thanks

Remster

 

[Aladin Akyurek]

Thanks, all. The 'Transpose' option works perfectly well for my purposes (yes, I have a lot of rows). If I find time, I'll try to work out why it works. I'll also try the last suggestion, out of interest.

You are welcome. Thaanks for providing feedback.

By the way, the FREQUENCY suggestion is indeed worth considering.