Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SUMIF by a Range

Status
Not open for further replies.
scott1971

scott1971

Technical User
Apr 20, 2005
125
EU
Guys,

I'm back again today with another problem and another Query, can you do a SUMIF based on a Range of numbers, for example:
SUMIF (A1:A10, "100,000 to 200,000")

I've tried a few variations but all to no avail.

Cheers

Scott
 
Sort by date Sort by votes
SUMIF(A1:A10, "<200000") - SUMIF(A1:A10, "<100000")

or

SUMPRODUCT((A1:A10<200000)*(A1:A10>100000))

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Question
Power Query Split by Table Group by Rows into a new set of group by tables
Replies
2
Views
214
remeng
remeng
N1GHTEYES
  • Locked
  • Question
Count areas within a range 1
Replies
14
Views
1K
SkipVought
S
N1GHTEYES
  • Locked
  • Question
Count range overlap cells
Replies
3
Views
459
N1GHTEYES
N1GHTEYES
PSchubert
  • Locked
  • Question
Excel - SUMIFS() works with one range, but doesn't with another nearly identical range 2
Replies
6
Views
323
Andrzejek
Andrzejek
BugZap13
  • Locked
  • Question
Excel formula to count occurrences of a value in a different sheet
Replies
5
Views
665
bs6600
bs6600

Part and Inventory Search

Sponsor

Back
Top