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.

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.

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.