help with formula for average

  • Thread starter Thread starter lynne
  • Start date Start date
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.
 
Hi
have you tried to add this a data item in your pivot table (instead of
a count/sum item)?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

help creating average formula 6
Pivot table Average with [h]:mm format 5
conditional formatting in pivot table 1
Pivot Table Average Problem 2
Average Question 2
How to ignore hidden columns in an "Average" formula? 8
average if 5
Averaging values 1

Back
Top