Mar 27 2021 10:12 AM - edited Mar 27 2021 10:20 AM
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))
Mar 27 2021 10:20 AM - edited Mar 27 2021 10:22 AM
@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.
Mar 27 2021 10:21 AM
SolutionMar 27 2021 10:24 AM
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
Mar 27 2021 10:40 AM
Mar 27 2021 10:21 AM
Solution
Use
=SUMPRODUCT(LEN(A9:Y9))*5
Note that the multiplication *5 is outside the parentheses.