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

A

AC-H

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.
 
B

Bob Phillips

You can use SUMPRODUCT to simulate it

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

--

HTH

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

AC-H

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?
 
Top