Custom Excel Formula - Extract number of 'items' in a cell

  • 11 August 2023
  • 1 reply

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:


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!!


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +14

Hi @10slindsay 

Good question.

Please reference this related topic: