I need to put / mark under each number, which represents a problem for the day. I will add a / each day of the for one week. Is there a way I can count all the / in each cell?
1 2 4 Total
//// /// /// 10
// /// 5
/ / / / 4
I need to put / mark under each number, which represents a problem for the day. I will add a / each day of the for one week. Is there a way I can count all the / in each cell?
1 2 4 Total
//// /// /// 10
// /// 5
/ / / / 4
If that's the only character the cells will have then try this...
Data Range
A B C D 1 1 2 4 Total 2 //// /// /// 10 3 // /// 5 4 / // / 4 5 ------ ------ ------ ------
This formula entered in D2 and copied down:
=SUMPRODUCT(LEN(A2:C2))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks