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