| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 49308 | 2004-09-15 12:58:00 | Excel function | bpt1 (419) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 272683 | 2004-09-15 12:58:00 | How do I use "sumif" where the criteria is a value range, e.g. ">100 <200" | bpt1 (419) | ||
| 272684 | 2004-09-15 16:25:00 | Hi, SumIf doesn't cater for multiple conditions. There are a few ways to evaluate multiple conditions but I prefer using SUMPRODUCT to achieve this. Syntax: =SUMPRODUCT((Criteria1)*(Criteria2),RangeToSum) You can have as many criteria as you like. Just place each criteria in brackets with * between the criteria in the first argument, then the range to sum in the second argument. Example: Say you have a range A1:A20 and you want to sum this range where the value is >100 and <200 ... =SUMPRODUCT((A1:A20>100)*(A1:A20<200),A1:A20) |
parry (27) | ||
| 1 | |||||