How do I add a formula to activate a pivot table list??
 

Can a SUMIF formula contain the AND function? If so how is it done?

I also would like to br able to link a list result to a List selection in a
Pivot table or can you insert a formula in the lists of a pivot table. If so
how. Please.

How do I add a formula to activate a pivot table list??
 

You can use SUMPRODUCT to simulate it

=SUMPRODUCT(--rng1="value1"),--(rng2=value2),rng3)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"AC-H" wrote in message
...
Can a SUMIF formula contain the AND function? If so how is it done?

I also would like to br able to link a list result to a List selection in
a
Pivot table or can you insert a formula in the lists of a pivot table. If
so
how. Please.

How do I add a formula to activate a pivot table list??
 

Hi Bob, Thanks for this but it would only work with externally created lists
and not with those connected with the Pivot table itself. Is there a way that
I can show you an expample of what I am trying to do?

"Bob Phillips" wrote:

You can use SUMPRODUCT to simulate it

=SUMPRODUCT(--rng1="value1"),--(rng2=value2),rng3)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"AC-H" wrote in message
...
Can a SUMIF formula contain the AND function? If so how is it done?

I also would like to br able to link a list result to a List selection in
a
Pivot table or can you insert a formula in the lists of a pivot table. If
so
how. Please.