Count only on visually populated cells
 

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



--
Neall

Count only on visually populated cells
 

Try this:

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

Biff

"Neall" wrote in message
...
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



--
Neall

Count only on visually populated cells
 

Awsome worked. Thanks
--
Neall


"T. Valko" wrote:

Try this:

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

Biff

"Neall" wrote in message
...
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



--
Neall

Count only on visually populated cells
 

You're welcome. Thanks for the feedback!

Biff

"Neall" wrote in message
...
Awsome worked. Thanks
--
Neall


"T. Valko" wrote:

Try this:

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

Biff

"Neall" wrote in message
...
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



--
Neall