help with formula for average

L

lynne

I need assistance figuring out how to add a column to an
existing spreadsheet that will give the average of NP's
which begins in J4:j2322, this is a pivot table report
already and I need to reflect the average for New clients
(less than 3 months with company) and the NP's for clients
with the program for more than 3 months. The column that
reflects new versus old is column d4:d2322. I need to
have the average be presented in one of the pivot tables.
 
F

Frank Kabel

Hi
have you tried to add this a data item in your pivot table (instead of
a count/sum item)?
 
Top