AVERAGEIF in pivot tables

Y

yowzers

How do I use the AVERAGEIF formula in a pivot table? I know how to use Pivot
Table Tools >Formuals >Calculated Fields. However, when I try to enter the
formula into the formula cell, I get an error message. Specifically, I'm
trying to do an AVERAGEIF of a column called Profits IF the value in profits
is >=0 and then <0
 
M

Michael.Tarnowski

How do I use the AVERAGEIF formula in a pivot table?  I know how to usePivot
Table Tools >Formuals >Calculated Fields.  However, when I try to enterthe
formula into the formula cell, I get an error message.  Specifically, I'm
trying to do an AVERAGEIF of a column called Profits IF the value in profits
is >=0 and then <0
Click to expand...

Hi yowzers,
not all Excel functions are available in pivot tables. In this cases
the use of a helper column may help.
HTH cheers Michael
 

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

AverageIf function with multiple columns 1
Averageif puzzle 5
Averageif Error 2
AVERAGEIF 4
averageif function and pivot tables 0
AVERAGEIF problem 3
averageif (XL2007) 2
Dealing with a Pivot Table (when I don't want to) 0

Top