Try autofilter for FP or NP then use the SUBTOTAL Function.

=SUBTOTAL(1,A1:A1000)

The "1" is Average


Gord Dibben MS Excel MVP

On Wed, 26 Mar 2008 10:22:00 -0700, pjr wrote:

the two main categories are "FP"(for profit) and "NP"(non profit). One column
is devoted to distinguishing between the two for each application. Is there a
way to pull data from cells that only sit in the same row as an "FP" or "NP" ?