cell count of 'grouped' cells

[Andy]

Apologies if this is a 'dumb' question! I am receiving data that is
layed out in groups. When I try to 'countif' with some of the group
not showing, I still get a full row count, including those rows not
showing.

Basically, I receive attendance stats with every days attendance
detailed, grouped into the weekly attendance per person. As I need
the number of people, I am trying to count just those (the second
group/layer), but when I try the countif(data,"*"), it counts all of
the rows, including the sub rows giving the daily info.

Please can someone help/explain what I need to do in order to only
count the cells within a certain group? Sorry if that does not make a
lot of sense; if someone can ask me for more info, I'll try and
explain it differently.

Any help/guidance/advice gratefully received.

Best regards
Andy

 

[Paul]

Apologies if this is a 'dumb' question! I am receiving data that is
layed out in groups. When I try to 'countif' with some of the group
not showing, I still get a full row count, including those rows not
showing.

Basically, I receive attendance stats with every days attendance
detailed, grouped into the weekly attendance per person. As I need
the number of people, I am trying to count just those (the second
group/layer), but when I try the countif(data,"*"), it counts all of
the rows, including the sub rows giving the daily info.

Please can someone help/explain what I need to do in order to only
count the cells within a certain group? Sorry if that does not make a
lot of sense; if someone can ask me for more info, I'll try and
explain it differently.

Any help/guidance/advice gratefully received.

Best regards
Andy

Most worksheet functions do not differentiate between cells that are visible
and those that are hidden. The exception is SUBTOTAL, which ignores cells
that are hidden as a result of filtering. This will not help you if your
cells are hidden as a result of grouping. So I think you need to approach
the problem differently to achieve what you need.

It really depends on the detail of how your data is structured. Say the
names are in column A. Does the same name appear several times on
consecutive rows, once for each day? If so, you want to count unique entries
in column A, which is described here:
http://www.cpearson.com/excel/duplicat.htm#CountingUnique