LinkBack URL
About LinkBacks
I think I understand.
Use the COUNT function to see how many cells are completed (per row) - then divide your total by this new columns value.
Example, if your data is in A1 to E1 and your total in F1
=F1\(COUNT(a1:e1))
I think I understand.
Use the COUNT function to see how many cells are completed (per row) - then divide your total by this new columns value.
Example, if your data is in A1 to E1 and your total in F1
=F1\(COUNT(a1:e1))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks