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.
Ooh yes - it says FALSE! So I guess it is not pulling through as a number - I wonder is it because I added the & "" to the end of the =sheet ? I wanted it to not show the blanks as 0s.
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.
esjay15 , you are welcome
Thank you this worked for me! SergeiBaklan