Formulas and Functions

[Gmema2u]

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

[#2]

@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. 

[#3 · Accepted solution]

@Gmema2u 

Use

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

Note that the multiplication *5 is outside the parentheses.

[#4]

@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

[#5]

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

[#6]

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