Problem with SUMIF Formula

S

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
 
P

Pete_UK

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

Hope this helps.

Pete
 
D

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
 
B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top