SUMIF in Office XP

D

Diane

Help

I've done a sumif function and it is referencing the
correct cells but is suming the row below.

ie =SUMIF($F$2:$EG$3,$G$3,F35:EG35) is actually suming row
F36:EG36.

Has anybody experienced this within XP (I've only found
this in XP) or is it a bug? Is there a work around -
using Arrays (bearing in mind I'm not that familiar with
arrays).

Thanks for your time
 
P

Peo Sjoblom

It's not a bug, it's because the dimension of the lookup range is larger
than the sum range, i.e.

you use 2 rows in the lookup range (rows 2 & 3) while the sum range is one
(row35)

Since the lookup value (G3) is in the second row of the range and if it is
not in the first row (row2)
it will sum the second row starting from 35 which is 36.
 
Top