Get instant live expert help on counta function in excel

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

COUNTA function to add cells with a specific inserted color
Solved by B. B. in 28 mins
I want to use the =INDEX(A:A,COUNTA(A:A),1) function but to be able to select the last 50 pieces of data
Solved by S. B. in 27 mins
Hello. I cannot get this formula to work. The two address functions work fine independently but not inside of the Median function. I suspect it's due to the fact that the Address functions result in a text value and the colon separates the two functions, but I'm baffled. Your assistance is appreciated. =MEDIAN(ADDRESS(COUNTA(B:B)-5,2):ADDRESS(COUNTA(B:B),2))
Solved by E. W. in 14 mins
I am new to the excel. what is the difference between count and countA
Solved by E. A. in 17 mins
I am trying to count the number of entries (a counta function) (dates) that are greater than another cell (another date) and am having trouble. Google sheets
Solved by O. J. in 26 mins