God morning, I don't know if n/a values can be counted, I've tried COUNT.IF but I'm not sure if I'm setting formula in the right form.
Thanks !
C
God morning, I don't know if n/a values can be counted, I've tried COUNT.IF but I'm not sure if I'm setting formula in the right form.
Thanks !
C
Yes you can count with COUNTIF function
Here are examples of how to count some of the erros located in column A
=COUNTIF(A:A,"#N/A")
=COUNTIF(A:A,"#DIV/0!")
=COUNTIF(A:A,"#NAME?")
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Try
=COUNTIF(A:A,NA())
Martin
It did work !
Thanks !
C
Thank you for the feedback!
Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).
Here's another one...
=SUMPRODUCT(--ISNA(A1:A10))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Another possibility if you're using Excel 2013...
Assuming the range contains TEXT or #N/A errors only. No numbers or other error values.
Array entered**:
=SUM(IFNA(A1:A10,1))
** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks