Forum Discussion

Gmema2u's avatar
Gmema2u
Copper Contributor
Mar 27, 2021
Solved

Formulas and Functions

Hello, can someone please help me with the proper formula for the below scenario?   I used a Tick symbol as the value. I am tracking student attendance. I would like to know the total Sum for each...
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Mar 27, 2021

    Gmema2u 

     

    Use

     

    =SUMPRODUCT(LEN(A9:Y9))*5

     

    Note that the multiplication *5 is outside the parentheses.

peteryac60's avatar
peteryac60
Iron Contributor
Mar 27, 2021

Gmema2u 

 

Hi

 

Attached is a possible solution - you count the blanks (using the COUNTBLANK function) rather than the tick symbols and then use the number for the calculation.

 

hope this helps.

 

Peter

  • Gmema2u's avatar
    Gmema2u
    Copper Contributor
    Mar 27, 2021
    Hi peteryac60, another Member shared the below formula with me which worked. Yeah. Thanks for your reply.

    Here is the formula: =SUMPRODUCT(LEN(A9:Y9))*5

Resources