View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Farhad Farhad is offline
external usenet poster
 
Posts: 281
Default Sumif with multiple criteria

Hi all,

i have a sheet and want to sum a column with 3 criteria like below:

A B C D
1 date kind1 kind2 amount
2 1/1/2006 silic toronto 10000
3 2/1/2006 Cab Quebec 2000
..
..

i want to sum amounts if dates are less than a date and kind1 is for example
silic and the kind2 is toronto can i use sumif?

any sugestion,

Thanks
--
Farhad Hodjat