Need help with Sum IF statement

[Scott02]

I'm looking for a little help with sumif statements. I understand how they work, but was wondering if there's a way to use Boolean to evaluate 2 ranges to 2 different criteria, and sum the third range. Here's an example:

Players 4
$ Min $25
Players 6
$ Min $10
Players 3
$ Min $100

I'm trying to sum the players into two categories if the $ Min is greater than $25 or less than $25. I am using a sumif to pull out sum of players if column A = "Players", but how can I build into the same formula to only return if the $ Min is within the range I want? Any suggestions would be appreciated. Thanks in advance!

Scott

 

[Lilliabeth]

Sorry, clear as mud to me.

Lilliabeth
-Why use a big word when a diminutive one will do?-

 

[Scott02]

Nevermind, we're trying something else. Thanks anyway.

 

[KenWright]

=SUMPRODUCT(--(A1:A20>5),--(B1:B20<20),C1:C20)

or perhaps

=SUMPRODUCT((A1:A20>5)*(B1:B20<20)*(C1:C20))

depending on your data

Regards
Ken.............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------