Get instant live expert help on I need help with excel counta function
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
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 am new to the excel. what is the difference between count and countA
Solved by E. A. in 17 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 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
i need a formula that can combine countif/counta with ignoring certain statements.
Solved by I. L. in 22 mins