Do Not count iserror cells

Is there a way to do a countif, or counta function and not have the formula
include the cells that return an error when they are blank. If the cell
returns an error it shows #NA, and is not considered blank when i do a counta
function.
--
Jeff

Try using IF(ISNA(Counta(.....)),"",counta(......))

"GoBucks" wrote:

> Is there a way to do a countif, or counta function and not have the formula
> include the cells that return an error when they are blank. If the cell
> returns an error it shows #NA, and is not considered blank when i do a counta
> function.
> --
> Jeff

=SUM(IF(NOT(ISERROR(A1:A10)),IF(A1:A10<>"",1,0)))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"GoBucks" <[email protected](DoNotSpam)> wrote in message
news:[email protected]...
> Is there a way to do a countif, or counta function and not have the
formula
> include the cells that return an error when they are blank. If the cell
> returns an error it shows #NA, and is not considered blank when i do a
counta
> function.
> --
> Jeff

tried both replies without any luck.. thanks though.
--
Jeff


"Bob Phillips" wrote:

> =SUM(IF(NOT(ISERROR(A1:A10)),IF(A1:A10<>"",1,0)))
>
> which is an array formula, it should be committed with Ctrl-Shift-Enter, not
> just Enter.
>
> --
> HTH
>
> Bob Phillips
>
> (replace somewhere in email address with gmail if mailing direct)
>
> "GoBucks" <[email protected](DoNotSpam)> wrote in message
> news:[email protected]...
> > Is there a way to do a countif, or counta function and not have the
> formula
> > include the cells that return an error when they are blank. If the cell
> > returns an error it shows #NA, and is not considered blank when i do a
> counta
> > function.
> > --
> > Jeff
>
>
>

Bob, that did work after all! thanks.
--
Jeff


"Bob Phillips" wrote:

> =SUM(IF(NOT(ISERROR(A1:A10)),IF(A1:A10<>"",1,0)))
>
> which is an array formula, it should be committed with Ctrl-Shift-Enter, not
> just Enter.
>
> --
> HTH
>
> Bob Phillips
>
> (replace somewhere in email address with gmail if mailing direct)
>
> "GoBucks" <[email protected](DoNotSpam)> wrote in message
> news:[email protected]...
> > Is there a way to do a countif, or counta function and not have the
> formula
> > include the cells that return an error when they are blank. If the cell
> > returns an error it shows #NA, and is not considered blank when i do a
> counta
> > function.
> > --
> > Jeff
>
>
>

There is better solution to this where you can use SUMPRODUCT to avoid using Ctrl+Shift+Enter.

=SUMPRODUCT(--NOT(ISERR(A1:A20)))

You can see it in Formula Explorer at https://www.sheetzoom.com/xlstools/0jssy4