Count only on visually populated cells

[Guest]

I have expressions pulling data from worksheet 2 to worksheet one only if the
data meets special criteria, however each cell has the expression (many OR
statements specific to each client), now on sheet 1 I am trying to do a
"COUNTA" to count the populated cells, however its picking up the or
statements even though not visable and counting them as well.

How can I perform a count on an area of cells and only get a results of
visually populated information

EX: =COUNTA(E10:F42) is counting an area and returning 65 cells, however
only 40 cells are visually populated, so I only want the count to return 40.

Thanks in advance

 

[T. Valko]

Try this:

=SUMPRODUCT(--(E10:F42<>""))

Biff

 

[Guest]

Awsome worked. Thanks
--
Neall

Try this:

=SUMPRODUCT(--(E10:F42<>""))

Biff

 

[T. Valko]

You're welcome. Thanks for the feedback!

Biff

Awsome worked. Thanks