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