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.
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?
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?