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.
If you want to return the value of cell D2 on a sheet named Expenses, you can use the formula
=Expenses!D2
If the sheet name contains spaces or looks like a number, enclose it in single quotes:
='Expenses Sheet'!D2
- Hi Hans,
Thanks for your comment - I have got this part already.
It is when I am trying to use these values in a sum formula - the formula is returning 0 when I know the value is more than this.
Does that make sense?Which exactly formula do you use? Like
=SUM(ExpensesA!D2, ExpensesB!D2)
or
=SUM(Expenses!D2:D100)
or what?
- =SUM(MSSSG!B17)
I would then add ,NextsheetXX, Nextsheet2XX
