sumif between 4300 and 4800

[ammartino44]

Hello. Can I do a sumif for between 4300-4800 (inclusive of 4800).

[quekbc]

Like this?

Please Login or Register  to view this content.

[Tony Valko]

Maybe this...

=SUMIF(A:A,">4300")-SUMIF(A:A,">4800")

[ammartino44]

Sorry I meant between 4300:4800 not minus.

[ammartino44]

I'm using this =SUMIFS(June!G:G,June!D:D,">4300<=4800",June!E:E, "122002") but it's not working right and it's difficult to check why with sumifs because there is nothing to step through.

[Tony Valko]

Like this...

=SUMIFS(June!G:G,June!D:D,">4300",June!D:D,"<=4800",June!E:E,122002)