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.