CODEWITHSUNDEEP
excelexcel-formulaminsumifs
Highbrook123512
Highbrook123512

Reputation: 13

Nested MIN within SUMIF formula

Problem: I can't seem to get the > MIN formula to work within SUMIFS

Requesting: Formula that will return the SUM of balloons IF the dollars amount is greater than the MIN

Expected output = 510,000 balloons

enter image description here

Note: This is just an example problem for easy comprehension. In reality the data set is much larger and I will include multiple IFs.

Upvotes: 1

Views: 1241

Answers (2)

basic
basic

Reputation: 11968

Even easier:

=SUMPRODUCT(--(B:B>MIN(B:B)),C:C)

Upvotes: 0

urdearboy
urdearboy

Reputation: 14580

You can sum the entire range and then just subtract the values from the range where the dollar amount is equal to the min $.

If your min value is repeated, they will all be removed from the sum.

=SUM(C:C) - SUMIF(B:B,MIN(B:B),C:C)

I believe you were attempting to do this in one sum equation which would look like this

=SUMIF(B:B,">"&MIN(B:B),C:C)

Upvotes: 2

Related Questions