Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I put more than one criterion in a SUMIF function?
Need to have both "12/31/2004" and "<02/01/2005" as criterion in a sumif.
|
#2
|
|||
|
|||
You use an array. Check out Chip Pearson's website....
http://www.cpearson.com/excel/array.htm HTH, -- Gary Brown Please rate this posting if it is helpful to you. "Bryan Brassell" wrote: Need to have both "12/31/2004" and "<02/01/2005" as criterion in a sumif. |
#3
|
|||
|
|||
This function will not work in my system. I am getting a #Value error. I
typed in the exact example from the Pearson page (the Phone/Smith example) and it will not work. Do I need some sort of add-in? Text of my formula and of example I loaded below: =SUM((Sheet2!$A$261:$A$269<DATEVALUE("03/01/2005"))*(Sheet2!$A$261:$A$269DATEVALUE("01/31/2005")) *Sheet2!H261:H2690) =SUM((A2:A10="Phone")*(B2:B10="Smith")*C2:C10) Either one gives me the same error. Any ideas? -- Regards, Bryan Brassell Padgett Business Services 281-897-9141 "Gary Brown" wrote: You use an array. Check out Chip Pearson's website.... http://www.cpearson.com/excel/array.htm HTH, -- Gary Brown Please rate this posting if it is helpful to you. "Bryan Brassell" wrote: Need to have both "12/31/2004" and "<02/01/2005" as criterion in a sumif. |
#5
|
|||
|
|||
Did you miss the Ctrl-Shift-Enter part that makes the formula an array?
HTH, -- Gary Brown Please rate this posting if it is helpful to you. "Bryan Brassell" wrote: This function will not work in my system. I am getting a #Value error. I typed in the exact example from the Pearson page (the Phone/Smith example) and it will not work. Do I need some sort of add-in? Text of my formula and of example I loaded below: =SUM((Sheet2!$A$261:$A$269<DATEVALUE("03/01/2005"))*(Sheet2!$A$261:$A$269DATEVALUE("01/31/2005")) *Sheet2!H261:H2690) =SUM((A2:A10="Phone")*(B2:B10="Smith")*C2:C10) Either one gives me the same error. Any ideas? -- Regards, Bryan Brassell Padgett Business Services 281-897-9141 "Gary Brown" wrote: You use an array. Check out Chip Pearson's website.... http://www.cpearson.com/excel/array.htm HTH, -- Gary Brown Please rate this posting if it is helpful to you. "Bryan Brassell" wrote: Need to have both "12/31/2004" and "<02/01/2005" as criterion in a sumif. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
How do I use the sumif if I have multiple criteria (i.e. greater . | Excel Worksheet Functions | |||
Dynamic sumif function | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
SUM(IF( Array to avoid #NUM! values | Excel Worksheet Functions |