# Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I would like to insert a formula which counts the number of filled rows (Number or text) beside column A in each cell of column of A for each row. For example. Cell A4 should count the number of filled cells beside from B4:BP4. Cell A5 should count the number of filled cells beside from B5:BP5. The cell in column A should stay blank if there is nothing to count
Solved by A. B. in 11 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 13/12/2017 - 02:14
User 13/12/2017 - 02:14
Hi!
Excelchat Expert 13/12/2017 - 02:14
Welcome to excel got it pro
User 13/12/2017 - 02:15
Thank you, did you get a chance to review my question?
Excelchat Expert 13/12/2017 - 02:15
IS it the excel file of yours?
User 13/12/2017 - 02:15
yes
Excelchat Expert 13/12/2017 - 02:15
yeah I did, you want to get a count of how many non empty cells in each rows, right?
User 13/12/2017 - 02:16
yes, that's right
Excelchat Expert 13/12/2017 - 02:17
I'm looking at the excel file, there's many sheet in it.
User 13/12/2017 - 02:17
right sorry! that would only be from the sheet "ManuelEntry". the file is protected. password:canada1
User 13/12/2017 - 02:18
you will have to unhide column A
Excelchat Expert 13/12/2017 - 02:18
got it
Excelchat Expert 13/12/2017 - 02:22
Sorry, I can't unprotect the sheet. Please use this formula in your sheet.
Excelchat Expert 13/12/2017 - 02:22
=IF(COUNTA(B4:BP4)>10,COUNTA(B4:BP4),"")
Excelchat Expert 13/12/2017 - 02:22
=IF(COUNTA(B4:BP4)>1,COUNTA(B4:BP4),"")
Excelchat Expert 13/12/2017 - 02:22
sorry this formula, the first one contains an error. use the second one.
User 13/12/2017 - 02:23
Okay, I'm testing it now one moment
Excelchat Expert 13/12/2017 - 02:23
User 13/12/2017 - 02:24
This is awesome, thank you!
Excelchat Expert 13/12/2017 - 02:25
my pleasure
Excelchat Expert 13/12/2017 - 02:25
anything else you wanna know on this?
Excelchat Expert 13/12/2017 - 02:25
If not please close the session and leave a feedback score for me.
Excelchat Expert 13/12/2017 - 02:25
to close the session click on the "end session" button.
User 13/12/2017 - 02:25
No problem, thanks for your help

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

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

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.