Problem with SUMIF Formula

[Steve M]

=SUMIF(BU$2:BU$246,"=7",(U$3:U$246))



I am trying to sum the values in column U where the corresponding value in
column BU is "7". I have used the above formula but it does not return all
values. I tried making this an array formula, but nothing changed. TIA

 

[Pete_UK]

Your first range covers rows 2 to 246 yet your second range covers
only rows 3 to 246.

Hope this helps.

Pete

 

[dschneiderch]

Your first range covers rows 2 to 246 yet your second range covers
only rows 3 to 246.

Hope this helps.

Pete

Second Pete's comment- With your arrays shifted, it is comparing the
value in bu(i) to 7 while summing the corresponding value at u(i+1).
So your formula is probably not so much missing values as it is
summing the wrong values.
ds

 

[baleshst]

=SUMIF(BU$2:BU$246,"=7",(U$3:U$246))

I am trying to sum the values in column U where the corresponding value in
column BU is "7". I have used the above formula but it does not return all
values. I tried making this an array formula, but nothing changed. TIA

-------------------------------------------------
There were flaws in your formula thats the reason it didnt work. Hope
this helps
=SUMIF(BU$2:BU$246,7,(U$2:U$246))

Balesh