Hi guys,
pls see my sheet, cell c28 is the issue.
I can't sweem to get countif working, to count cells excluding N/A. Can anyone help?
thank you!
Hi guys,
pls see my sheet, cell c28 is the issue.
I can't sweem to get countif working, to count cells excluding N/A. Can anyone help?
thank you!
Thanks,
R.
The attached workbook is referring to a workbook we don't have.
Are you counting or summing? Either way, COUNTIFS or SUMIFS will be what you need so that you can add a criterion to exclude N/A from the calculation.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Please try
=COUNTIF(B1:B23, "<>N/A")
sorted. thanks!!
Last edited by AliGW; 05-29-2019 at 07:35 AM. Reason: Please don't quote unnecessarily!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks