software

I have a worksheet that has data for new items, repaired items, and some with
no values. I use autofilter to select only the rows for the repaired items,
and I want to do an average of these items only. when I put the funtion in,
it selects every row, rather than only the visible ones. Short of having to
click through each individual row for the average, is there an easy way to do
this? Thanks.

Look in Help at SUBTOTAL

HTH
--
AP

quot;Jude Sweeneyquot; lt;Jude gt; a écrit dans le
message de news: ...
gt;I have a worksheet that has data for new items, repaired items, and some
gt;with
gt; no values. I use autofilter to select only the rows for the repaired
gt; items,
gt; and I want to do an average of these items only. when I put the funtion
gt; in,
gt; it selects every row, rather than only the visible ones. Short of having
gt; to
gt; click through each individual row for the average, is there an easy way to
gt; do
gt; this? Thanks.
Perfect - exactly what I was looking for. Thanks!

Jude

quot;Ardus Petusquot; wrote:

gt; Look in Help at SUBTOTAL
gt;
gt; HTH
gt; --
gt; AP
gt;
gt; quot;Jude Sweeneyquot; lt;Jude gt; a écrit dans le
gt; message de news: ...
gt; gt;I have a worksheet that has data for new items, repaired items, and some
gt; gt;with
gt; gt; no values. I use autofilter to select only the rows for the repaired
gt; gt; items,
gt; gt; and I want to do an average of these items only. when I put the funtion
gt; gt; in,
gt; gt; it selects every row, rather than only the visible ones. Short of having
gt; gt; to
gt; gt; click through each individual row for the average, is there an easy way to
gt; gt; do
gt; gt; this? Thanks.
gt;
gt;
gt;