Forum Discussion

Copper Contributor

Jul 09, 2022

Solved

Can someone please explain how B9 is calculating this answer [Formula is (=SUM(B4-(B5:B8))]?

Formulas and Functions

Riny_van_Eekelen
Jul 09, 2022
Priyanshu1325 That would be 1000-100 + 1000-150 + 1000-300 + 1000-100 = 3350

Diamond Contributor

Jul 09, 2022

B4-B5:B8 gives

1000-100

1000-150

1000-300

1000-100

after that you sum results

Priyanshu1325
Copper Contributor
Jul 10, 2022
But won't this violate order of operations? How does excel read/interpret (B5:B9)?

Resources