 SOLVED

New Contributor

# Formulas and Functions

I used a Tick symbol as the value. I am tracking student attendance.

I would like to know the total Sum for each row. Each row represents a student.

For example, there are 31 Tick symbols on row 9 (columns A thru Y).

Each Tick symbol represents \$5.00 per day.

I have tried multiple formulas. The below is the latest formula I tried.

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

5 Replies

# Re: Formulas and Functions

@Gmema2u Try this:

``=SUM(LEN(A9:Y9)*5)``

Not sure though why you chose to use tick marks. Why not just a number 1. So much easier to calculate with numbers.

best response confirmed by Gmema2u (New Contributor)
Solution

# Re: Formulas and Functions

Use

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

Note that the multiplication *5 is outside the parentheses.

# Re: Formulas and Functions

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

# Re: Formulas and Functions

It worked! Yeah!!! Thank you so very much!

# Re: Formulas and Functions

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