| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
|
#3
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use the sumif if I have multiple criteria (i.e. greater . | Excel Worksheet Functions | |||
| SUMIF, multiple criteria | Excel Discussion (Misc queries) | |||
| sumif with multiple criteria | Excel Worksheet Functions | |||
| How do I sum (like sumif) but predicated on multiple criteria, in. | Excel Worksheet Functions | |||
| How do I ask for multiple criteria when creating a "sumif" formul. | Excel Worksheet Functions | |||
Linear Mode
