Hello. Can I do a sumif for between 4300-4800 (inclusive of 4800).
Hello. Can I do a sumif for between 4300-4800 (inclusive of 4800).
Like this?
Formula:Please Login or Register to view this content.
Maybe this...
=SUMIF(A:A,">4300")-SUMIF(A:A,">4800")
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Sorry I meant between 4300:4800 not minus.
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.
Like this...
=SUMIFS(June!G:G,June!D:D,">4300",June!D:D,"<=4800",June!E:E,122002)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks