Data is like
alkdjs
sdlfkjas
asldfkj
adfljk
What will be Formula Here to Count Above Cells with Text Value ??????
asdlfkja
asdldsfj
It should Show As "2" When Formula is applied ?????? (Remember i don't have to apply formula in this cell only it should work for entire row)
asdlfja
dlkj
sdkjflkjadsf
asdlkj
adlsfjk
Count????
Please help if data is like text instead of numbers what will be formula Desired result is Count of Cells with Value eg. 4,2,5
Enter formula in B2 and copy down
Formula:
Please Login or Register to view this content.
v A B 1 2 alkdjs 3 sdlfkjas 4 asldfkj 5 adfljk 6 4 7 asdlfkja 8 asdldsfj 9 2 10 asdlfja 11 dlkj 12 sdkjflkjadsf 13 asdlkj 14 adlsfjk 15 5
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Or try this in B2 ...
=IF((A2="")*(A1<>""),COUNTA($A$2:A2)-SUM($B$1:B1),"")
Last edited by Phuocam; 06-09-2016 at 11:30 PM.
Used This one =+IFERROR(IF(A3="",COUNTA($A$2:A2)-SUM($E$2:E2),""),"Wrong") and Worked like a CharmThanks a lot
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks