ExcelBanter - HOW 2 COUNT ERRORS?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - HOW 2 COUNT ERRORS? (https://www.excelbanter.com/excel-discussion-misc-queries/208916-how-2-count-errors.html)

FARAZ QURESHI

HOW 2 COUNT ERRORS?

Any formula to count the number of #N/A type errors in cells A1:G1?
--
Best Regards,
FARAZ A. QURESHI

Mike H

HOW 2 COUNT ERRORS?

Hi,

Try this

=SUM(0+ISNA(A1:G1))

This is an array formula which must be entered by pressing CTRL+Shift+Enter
and not just Enter. If you do it correctly then Excel will put curly brackets
around the formula {}. You can't type these yourself. If you edit the formula
you must enter it again with CTRL+Shift+Enter.

Mike

"FARAZ QURESHI" wrote:

Any formula to count the number of #N/A type errors in cells A1:G1?
--
Best Regards,
FARAZ A. QURESHI

Pete_UK

HOW 2 COUNT ERRORS?

Try this:

=COUNTIF(A1:G1,NA())

Hope this helps.

Pete

On Nov 4, 1:18*pm, FARAZ QURESHI
wrote:
Any formula to count the number of #N/A type errors in cells A1:G1?
--
Best Regards,
FARAZ A. QURESHI

Jerry W. Lewis

HOW 2 COUNT ERRORS?

Two related possibilities are
=SUMPRODUCT(ISNA(A1:G1)*1)
=SUMPRODUCT(--ISNA(A1:G1))
SUMPRODUCT usually does not require array entry. *1 or -- coerces the
ISNA() array from T/F to 1/0.

Jerry

"FARAZ QURESHI" wrote:

Any formula to count the number of #N/A type errors in cells A1:G1?
--
Best Regards,
FARAZ A. QURESHI

All times are GMT +1. The time now is 04:14 PM.