CountA function to Count Blanks

[Alaska1]

I need to count the number of company's that are blank in three data fields. H, I, J. The data is in dynamic table Because I will continue to add. Do I need to use the Count A function for this? I have attached a sample worksheet.

[Pecoflyer]

Try the COUNTBLANK function instead.

Define your range a s a Table to make it dynamic

[Alaska1]

Thank you. The countblank function did not work for that. I need to count the number of companies with those three fields missing. My data is in a table.

[gebobs]

=COUNTIFS(Table1[Theme1],"",Table1[theme2],"",Table1[Theme3],"")

[Alaska1]

Thank you. I have that formula already. That counts the number of blank cells for all three. It give me the number of 600. I need the number of companies which would be 122 where all three fields are blank.

[gebobs]

There must be some mistake. When I use that formula, I get 120.

I checked this with the formula:
=IF(COUNTBLANK(Table1[@[Theme1]:[Theme3]])=3,1,0)

The file is attached.

[Alaska1]

Thank you. It worked when I did it in the sample. I got 120 this time. The only thing is I cannot use #this row because I have all my reporting on one worksheet. I want it to be able to total on a separate worksheet. If I use this row it has to be in the main document.

[gebobs]

See the cell in M2 of sheet2? Copy and paste it wherever you like in the workbook. See attached.

[Alaska1]

Thank you for your help. I will use the formula in the attached document. Thank you again.

[macropod]

You could try:
=SUMPRODUCT((Sheet1!$H2:$H264="")*(Sheet1!$I2:$I26 4="")*(Sheet1!$J2:$J264=""))

[Alaska1]

Hello,

Thank you for your reply.