![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/ab389eb8-98c2-4923-a182-82fcb28a3649.png)
In ColE, I want to return a count of the number of items in ColD. This is zapped in from my CRM, and at the moment this is a manual process. I would like to automate the process so that I can send the count (colD) back to my CRM.
The correct formula is shown in excel, but I am struggling with the Zapier format options. I have gone through various text formatter options, but keep getting 'syntax error’ with the below:
![](https://uploads-us-west-2.insided.com/zapier-ca/attachment/fc49a66a-add0-4d9e-af84-3faa1ef11258.png)
I am wondering how I get Zapier to specifically supply the cell reference (i.e, D2) instead of the cell value (the string value). I may be way off the mark here, but I feel it is close to working!
Any help or guidance or discussion is much appreciated.
Many thanks!!
Sam