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.

Attached Files

Book1.xlsx (27.6 KB, 11 views)

Try the COUNTBLANK function instead.

Define your range a s a Table to make it dynamic

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

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.

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

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.

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.

Attached Files

Book1 (3).xlsx (30.9 KB, 12 views)

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.

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

Attached Files

Book1 (3).xlsx (31.0 KB, 11 views)

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

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

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hello,

Thank you for your reply.