Can I use multiple criteria in SUMIF funqtion?
 

Can I use multiple criteria in SUMIF funqtion?
For example, I want date and quantity sold to be criterias that filter out
the data and I do not want to use DSUM funqtion. I am using Excel 2003.

Hi Levan

See John's site
http://www.j-walk.com/ss/excel/tips/tip74.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Levan Alibegashvili" <Levan wrote in message
...
Can I use multiple criteria in SUMIF funqtion?
For example, I want date and quantity sold to be criterias that filter out
the data and I do not want to use DSUM funqtion. I am using Excel 2003.

Do you just want a sum?

=SUMPRODUCT(--(A2:A100="value1"),--(B2:B100=17),C2:C100)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Levan Alibegashvili" <Levan wrote
in message ...
Can I use multiple criteria in SUMIF funqtion?
For example, I want date and quantity sold to be criterias that filter out
the data and I do not want to use DSUM funqtion. I am using Excel 2003.