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
Microsoft ExcelMicrosoft Office
Last Comment
Rob Henson
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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