Sumif with multiple criteria
Here it is :-) enjoy!!
A B C D
date kind1 kind2 amount
1/1/2007 slic toronto 2
1/1/2005 slic toronto 1
1/2/2007 cab quebec 1
1/1/2007 slic toronto 2
1/4/2007 slic quebec 1
1/5/2007 cab quebec 1
1/1/2007 slic toronto 2 in this box you write:
6 =SUMPRODUCT(--(A2:A8DATE(2006,1,1)),--(B2:B8="slic"),--(C2:C8="toronto"), D2:D8)
"Farhad" wrote in message ...
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
|