Forum Discussion
Solved
How to use a formula on cells pulled from another sheet
Hi, This is probably quite simple but i can't find the workaround. I am pulling in separate budgets in different spreadsheets - populating them into their own tab on an overall spreadsheet (us...
Yes, you have text which is not summed. Two variants
1) Use =SUM( VALUE(sheet!B17) )
2) In sheet use =IF( SUM(range), SUM(range), "") instead of =SUM(range) & ""
Actually you don't need SUM with referencing, =VALUE(sheet!B17) is enough. If you don't do any calculations with that, when =sheet!B17.
In the cell where you want to apply the formula, start by typing the equal sign (=) to indicate that you're entering a formula. Then, navigate to the source https://calculadoraalicia.online/ sheet by typing the sheet name followed by an exclamation mark (!). For example, if the source sheet is named "Sheet2", you would type "Sheet2!".
That's out of scope. The question is why =SUM(<such reference as you suggested>) returns 0.