Forum Discussion
Simple math formula returning multiple values (It should not)
Hi. I have a simple work sheet setup it has 7 columns. I am doing a formula =(B2*C2)+(D3:J3). Excel keeps on wanting to return multiple results, using up 7 columns for the answer. In...
michael_Korn1979 Perhaps you want to use:
=(B2*C2)+SUM(D3:J3)
Ok that fixed the problem. Thank you. Now why was it doing that? I have used excel for years, and I have done it this way for years. Never had a problem until today