Formula adjustment

[ironsides]

This formula below is correct as it stands
the Col AB range is .10 :999.99

I want to adjust this formula to include
subtract 10:19.99

=SUMIFS($AD$19:$AD$99599,$AD$19:$AD$99599,">=.10",$AB$19:$AB$99599,"<=999.99")

( the sum of Col AB : Add .10 to 9.99 subtract 10 to 19.99 add 20 to 999.99)

 

[StephenCrump]

This formula below is correct as it stands

=SUMIFS($AD$19:$AD$99599,$AD$19:$AD$99599,">=.10",$AB$19:$AB$99599,"<=999.99")

I think you meant:

=SUMIFS($AD$19:$AD$99599,$AB$19:$AB$99599,">=.10",$AB$19:$AB$99599,"<=999.99")

In which case, try:

=SUMIFS($AD$19:$AD$99599,$AB$19:$AB$99599,">=.10",$AB$19:$AB$99599,"<1000")-2*SUMIFS($AD$19:$AD$99599,$AB$19:$AB$99599,">=10",$AB$19:$AB$99599,"<20")

 

[ironsides]

The sum I got was unexpected
I ran the program your way and my original.
The result was duplicate
I made adjustment but to no avail

 

[ironsides]

StephenCrump

This is the one that works

=SUMIFS($AD$19:$AD$95591,$AD$19:$AD$95591,">=.10",$AB$19:$AB$95591,"<1000")-2*SUMIFS($AD$19:$AD$95591,$AB$19:$AB$95591,">=10",$AB$19:$AB$95591,"<20")

Thank you for this formula
Matt

 

[StephenCrump]

This is the one that works

=SUMIFS($AD$19:$AD$95591,$AD$19:$AD$95591,">=.10",$AB$19:$AB$95591,"<1000")-2*SUMIFS($AD$19:$AD$95591,$AB$19:$AB$95591,">=10",$AB$19:$AB$95591,"<20")

No. That formula can't be correct.

If your original formula really was =SUMIFS($AD$19:$AD$99599,$AD$19:$AD$99599,">=.10",$AB$19:$AB$99599,"<=999.99") (which looks odd to me)

then you will need:

=SUMIFS($AD$19:$AD$95591,$AD$19:$AD$95591,">=.10",$AB$19:$AB$95591,"<10")-SUMIFS($AD$19:$AD$95591,$AD$19:$AD$95591,">=10",$AB$19:$AB$95591,"<20")+SUMIFS($AD$19:$AD$95591,$AD$19:$AD$95591,">=.20",$AB$19:$AB$95591,"<1000")

But that would be an even weirder sum!

 

[ironsides]

I have to look at this later so see where I'm amiss

 

[ironsides]

The answer is this
Your formula works when i changed.......<1000")-2*SUMIFS($A.... to

.....<1000")-1*SUMIFS($A.....

Again thanks

Matt