sumif

J

Jess

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.
 
D

David Biddulph

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.
 
V

Vergel Adriano

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.
 
Top