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...
Perhaps you meant =B2*C2+SUM(D3:J3) ?
Without a function such as SUM that returns one value, you'll get a multi-cell result in Excel 2021 and Excel 365.