Formula Help: Add cells with certain text + cells that are blank

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Nicole L. - 26 Feb 2007 20:32 GMT

I know this is easier than I'm making it out to be - It's got to be!

I need to count cells in a column only if they are blank or if they contain
a specified text (in this case, it happens to be "N/A").

What formula do I use?

Reply to this Message

Lost in Microbiology - 26 Feb 2007 20:53 GMT

There may be easier ways, but in an adjacent cell, click, Insert then
Function, then Countblank, a dialog box will appear. Select the range of
cells and the formula will return your blanks. Subtract the number of blank
cells from the total and it will give you the number of "N/A" cells.

> I know this is easier than I'm making it out to be - It's got to be!
>
> I need to count cells in a column only if they are blank or if they contain
> a specified text (in this case, it happens to be "N/A").
>
> What formula do I use?

Reply to this Message

Nicole L. - 26 Feb 2007 21:03 GMT

Actually, I need to count cells that are blank and cells that have "textA" in
them.

> There may be easier ways, but in an adjacent cell, click, Insert then
> Function, then Countblank, a dialog box will appear. Select the range of
[quoted text clipped - 7 lines]
> >
> > What formula do I use?

Reply to this Message

Teethless mama - 27 Feb 2007 06:59 GMT

=COUNTIF(A1:A12,"textA")+COUNTBLANK(A1:A12)

Adjust your range to suit

Reply to this Message