A
Alfred Lavallee
Can =counta be used to determine the count of a filtered
portion of a large amount of data. That is, in the cell
used, can a formula be written to include all as well as
just the amount of items that are filtered? For example,
in the cell you put =counta(a2:a650) and 649 comes up. If
you now set the filter and filter only on one group, can
that same cell give you say the 100 that are in that
particular group?
portion of a large amount of data. That is, in the cell
used, can a formula be written to include all as well as
just the amount of items that are filtered? For example,
in the cell you put =counta(a2:a650) and 649 comes up. If
you now set the filter and filter only on one group, can
that same cell give you say the 100 that are in that
particular group?