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.
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 [email protected]> wrote in message
news:[email protected]...
> 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 [email protected]> wrote
in message news:[email protected]...
> 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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks