Get instant live expert help on I need help with excel count non blank cells

“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

I need to update a formula on the "Summary Tab 2" in cell E3. The formula currently totals non-blank cells on two rows on the "Tracker" tab with the condition that "Amy Perkins" is in the 3rd row. Instead of counting non-blank cells, I want to count cells with dates in between or equal to 1/1/2018 and 6/30/2018 (still with the condition of "Amy Perkins" being in the third row.
Solved by F. B. in 30 mins
Hello - In my Excel spreadsheet, I need to get the value of the non-blank cell in (non-adjacent cells) row. Here is a small example. Row # AD5 AI5 AN5 AS5 RESULT Cell Value AM AM Row # AD6 AI6 AN6 AS Cell Value BW BW
Solved by B. L. in 11 mins
I have a formula that does excel count non blank cells in Cell A2 now i want to create another array formula where in i want to use this count as one of the reference i.e. $F$1:$F$(value in cell A2). Please advice?
Solved by B. C. in 19 mins
i need to adjust a formula to not count blank cells
Solved by Z. J. in 13 mins
I need help formulating a non-traditional excel correlation function that involves non-contiguous columns AND non-contiguous cells within the columns.
Solved by D. U. in 23 mins