CODEWITHSUNDEEP
excelexcel-formulasumifs
dhacohen
dhacohen

Reputation: 47

SumIfs() not working for a value between a range

I'm trying to solve an exercise with the SumIfs() formula (mine is in Spanish) but I can't make it to work correctly....

The first table (ID and price) has all values and I want to sum all values from every ID that are between a range of values (from, to) but I'm doing something wrong and don't know what....

Worksheet

Thanks for your valuable help! regards, Daniel

Upvotes: 0

Views: 2819

Answers (1)

Gizzmo
Gizzmo

Reputation: 11

Your formula looks fine, what appears to be the problem is the FROM and TO parameters.

For example:

For OBMMSE FROM if you change the 2721 to 2721000 and For OBMMSE To if you change the 2779 to 27790000 you will get a result of 65154250 which is the total B3+B4+B6+B7

This tells me the formula is correct or working but the data in column B is outside the parameters for FROM and TO for each ID.

Hope this helps.

BTW this in effect is the same answers as guitarthrower

Upvotes: 1

Related Questions