Error says: Error Function MINUS parameter 1 expects number values. But ’ ’ is a text and cannot be coerced to a number.
One error in each cell Cells H33 and H48
Is this with Google Sheets or Microsoft Excel?
Sorry, google sheets.
I don’t see any MINUS function calls anywhere in the Monthly Budget sheet? 
Can you post the formula in the cell with the Error?
H-column is labeled “AVAILABLE”.
Cell H16 is this arrayformula, which would fill the entire column with data, I believe:
=arrayformula(if(isblank(B16:B),iferror(1/0),if(counta($N$16:$N)=2,if(row($G16:$G)-row($G$16)>=max($N$16:$N),F16:F-G16:G,G16:G-F16:F),if($Q$16="Income",G16:G-F16:F,F16:F-G16:G))))
I’m not good with Google sheets yet. Looks like the same. I grabbed the formula from the Header.
=arrayformula(if(isblank(B16:B),iferror(1/0),if(counta($N$16:$N)=2,if(row($G16:$G)-row($G$16)>=max($N$16:$N),F16:F-G16:G,G16:G-F16:F),if($Q$16=“Income”,G16:G-F16:F,F16:F-G16:G))))
What is formula in cell H33, the one with the Error?
How do i see that. Sorry, you are working with a real rookie here.
Select the cell and formula displays in the fx bar, here’s H16 partial snapshot:
Not seeing it.
Is there a way I can delete the sheet and copy the one from the original spreadsheet.
To restore the Monthly Budget template, select:
Menu > Extensions > Tiller Money Feeds > Templates
Select Restore Template for the Monthly Budget.
Okay, let me try that, then I have to leave this for the afternoon. Thanks f the assist. I’m starting this new so I’m trying to learn a lot. Again Thanks @Mark.S
Hey @Mark.S - Restore worked perfect! Thanks Again!
1 Like