SUMIF in Office XP

  • Thread starter Thread starter Diane
  • Start date Start date
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
 
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.
 
Back
Top