Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif
Hello,
I've seen a lot of good advice about the function sumif. But I have te problem that my range criteria has not the same size as the sumrange. Can someone help me whith this problem. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif
I'm struggling to understand what you are trying to achieve? I thought that
the idea of SUMIF() was that if an entry in one vector meets the criterion, then the corresponding element in the other vector is used in the sum. If the vectors aren't of identical size, how do you decide which is the corresponding element to add? Maybe you need to give us an example of what you're trying to do. -- David Biddulph "Jess" wrote in message ... Hello, I've seen a lot of good advice about the function sumif. But I have te problem that my range criteria has not the same size as the sumrange. Can someone help me whith this problem. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumif
I believe the range and sum_range must be of the same size in order for Excel
to evaluate each cell wether or not to include the value in the sum. Perhaps provide more detail on what it is that you're trying to do and maybe there's a different approach other than SUMIF. "Jess" wrote: Hello, I've seen a lot of good advice about the function sumif. But I have te problem that my range criteria has not the same size as the sumrange. Can someone help me whith this problem. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif #value | Excel Worksheet Functions | |||
SUMIF | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |