Thread: SUMIF WITH OR
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lea from CA[_2_] Lea from CA[_2_] is offline
external usenet poster
 
Posts: 10
Default SUMIF WITH OR

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!