Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Add COUNTA Values


I have 4 variables I created using COUNTA functions:

VARIABLE = 
VAR __1 = COUNTA()
VAR __2 = COUNTA()
VAR __3 = COUNTA()
VAR __4 = COUNTA()

How can I sum these fours variables? The values are in form of text. 

  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Nejovic,

     

    Just add return function at the end like,

     

    return VAR__1 + VAR__2 + VAR__3 + VAR__4

     

    Regards,

    Pradeep

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Nejovic,

     

    Just add return function at the end like,

     

    return VAR__1 + VAR__2 + VAR__3 + VAR__4

     

    Regards,

    Pradeep

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you!