Hi Biff
Great shut,I forgot, they could be group that way, makes it much neater.
Have a good evening.
John
"T. Valko" wrote in message
...
One way...

=SUMPRODUCT((A1:A20=1)*(B1:B20={"A","B","C"})*C1:C 20)

--
Biff
Microsoft Excel MVP


"Lea from CA" wrote in message
...
I have a table with 3 columns of data - Column A Store Number, Column B Dept
& Column C Amount. There are several store numbers and 10 distinct Depts
(Dept A - J. I want a sum of amounts where store# = 1 and dept is Dept A,
Dept B and Dept C.

Any help will be greatly appreciated.

Thanks!