Trouble copying formulas into new sheet

sarahamel

Hello All!

I am having difficulty copying formulas from one sheet to the next- I keep getting "UNPARSEABLE". I have tried copying/pasting in multiple ways, no luck.

Details: Formulas look like =COUNTIFS(Type:Type, "GC", Team:Team, "TM") , "Type" and "Team" being columns in each separate monthly sheet. If the columns are named the same, shouldn't pasting the formulas into the new sheet load the data from that sheet?

Thank you in advance for any advice!

Brian_Richardson

Yes copying should work fine. There's probably a subtle difference in the column names, an extra space or something. When you paste the formula you should see the column names turn color…if they are still black then that means it's not finding those columns on the sheet that you're posting to.

Another problem may be that your paste is not including the trailing ) which will also result in UNPARSEABLE