=SUMPRODUCT(--(A2:A200="small"),--(B2:B20099))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"NeedHelpFast" wrote in message
...
I have t-shirt sizes in col. B of a Pivot Table. A shirt is given to
someone
who had deposited over $99. The deposit is in col. E of the same Pivot
Table.
How do I write the formula to find the total 'small', 'med', etc for those
who deposited over $99. I keep getting an error message.