Tom M

asked on

# Sum if within a range of numbers

Is it possible to write a simple formula to sum numbers in a specific range? In my test file here I have a trial balance that has account numbers in Column A and the balances in Column B. I would like to sum the balance of all account numbers between 391 to 398.10

test.xlsx

test.xlsx

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Is account 398.10 "398 point ten", ie the tenth sub account in 398 or is it 398 point one, the first sub account?

Likewise, where does 398.2 come in that group? Is it second sub account or twentieth.

The reason I ask, if 398.2 is actually the second but 398.10 is the tenth, summing up to 398.1 will ignore 398.2 because, as a number, it is greater than 398.1