P
PegL
The countif function suggested will work. However, if you
need to repeatedly get this, you might look at using the
Auto Filter function and subtotals. When used together,
the subtotal will show the value only for the selected
rows.
need to repeatedly get this, you might look at using the
Auto Filter function and subtotals. When used together,
the subtotal will show the value only for the selected
rows.