Thread: Formula Help: Add cells with certain text + cells that are blank
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Formula Help: Add cells with certain text + cells that are blank
=COUNTIF(A1:A12,"textA")+COUNTBLANK(A1:A12)

Adjust your range to suit


"Nicole L." wrote:

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 With QuoteReply With Quote