SUMIFS with value under amount

[riverman27]

Hi Guys,

First post here so dont beat me up about this lol.

I am not sure what I am doing wrong and need some help please.

I have values in column G, currency in I, and need to see how many of a certain currency is below 1000, however the formula I am using isnt working.

=SUMIFS(G:G,I:I,C1709,amount,"<=1000")

GG being the sum_range, II, being the currency range,C1709, being the criteria for the currency, then adding the amount below....

Any ideas would be appreciated.

Thanks

 

[Aladin Akyurek]

What is the cell range for amount?

 

[Scott T]

Try

=SUMIFS(G:G,I:I,"<=1000")

 

[riverman27]

G:G is the cell range for the amount.

 

[riverman27]

Unfortunately its seeing "<=1" as another criteria, as it has no range it returns no results ;-(

 

[Aladin Akyurek]

Try...

=SUMIFS(G:G,I:I,C1709,G:G,"<=1000")

 

[riverman27]

Perfect that works Aladin.

Appreciate the help all!

 

[Aladin Akyurek]

You are welcome.