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.