| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif formula
I need to calculate a total using a sumif function based of a range of
numbers. For instance, my criteria for the sumif needs to be "for any cells whose value is between 10 and 20". How would you write that formula? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sumif formula
=SUMPRODUCT(--(A1:A10010),--(A1:A100<20),A1:A100)
"alm09" wrote: I need to calculate a total using a sumif function based of a range of numbers. For instance, my criteria for the sumif needs to be "for any cells whose value is between 10 and 20". How would you write that formula? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sumif formula
between 10 and 20 might be = 10 <=20 ??? depending on what is desired.
=SUMPRODUCT(--(A1:A10010),--(A1:A100<=20),A1:A100) -- Don Guillett SalesAid Software "Teethless mama" wrote in message ... =SUMPRODUCT(--(A1:A10010),--(A1:A100<20),A1:A100) "alm09" wrote: I need to calculate a total using a sumif function based of a range of numbers. For instance, my criteria for the sumif needs to be "for any cells whose value is between 10 and 20". How would you write that formula? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sumif formula
try
=sumif(range,"10")-sumif(range,"=20") "alm09" wrote: I need to calculate a total using a sumif function based of a range of numbers. For instance, my criteria for the sumif needs to be "for any cells whose value is between 10 and 20". How would you write that formula? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help with sumif formula with multiple critera | Excel Worksheet Functions | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Match then lookup | Excel Worksheet Functions | |||
| formula (perhaps sumif?) | Excel Discussion (Misc queries) | |||
| Array Formula w/ Multiple SumIf Criteria | Excel Worksheet Functions | |||
Linear Mode
