SUMIFS- Need to sum a column based on a range of numbers

[Apples52]

Hi,
This seems simple enough but I can't get this formula to work properly. In cell J2 I am wanting to return the sum of column H if the value in column G is between 4000 & 4999. The latest formula I've tried is

=SUMIFS(H2:H4082,G2:G4082,">=4000",G2:G4082,"<=4999")

It is returning no value. Where am I going wrong?

 

[NickFru]

Hello - try this =SUMIFS(H2:H4082,G2:G4082,">="&4000,G2:G4082,"<="&4999)

 

[Apples52]

Hello - try this =SUMIFS(H2:H4082,G2:G4082,">="&4000,G2:G4082,"<="&4999)

Hmm, that solution didn't work either. Returned a value of 0. But I appreciate you taking the time to reply

Edit: Both my formula and your revision worked after Fluffs comment on converting text to numbers in col G

 

[Fluff]

Convert the text in Col G to numbers & then your formula will work.

 

[Apples52]

Hello - try this =SUMIFS(H2:H4082,G2:G4082,">="&4000,G2:G4082,"<="&4999)

Hmm, that solution didn't work either. Returned a value of 0. But I appreciate you taking the time to reply

Convert the text in Col G to numbers & then your formula will w

Ahhh, yes, that did it! So both my formula and the revision suggestion from NickFru worked after that. After looking at rows and rows of data too long, those little things often get lost. Thanks so much!

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[NickFru]

Ah no problem at all, glad you got it sorted.