drom
Well-known Member
- Joined
- Mar 20, 2005
- Messages
- 528
- Office Version
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
Hi and thanks in advance
I have a table with 9 columns.
Any of the columns within the table has every row/cell with info
i mean some times the cells are empty within the different columns.
If I filter my Table "Table1" according to column A, B and C
I would like to count how many blank cells are within my filtered table in column D.
I was trying to adapt this
Any Help ?
ps: I do not want to use/add one more Column to update the above formula
J5= rand() and then:
I would like to use references to just one Column the Column D
I have a table with 9 columns.
Any of the columns within the table has every row/cell with info
i mean some times the cells are empty within the different columns.
If I filter my Table "Table1" according to column A, B and C
I would like to count how many blank cells are within my filtered table in column D.
I was trying to adapt this
=SUMPRODUCT(SUBTOTAL(3,OFFSET(A5:A200,ROW(A5:A200)-ROW(A5),,1)),--(D5:D200=""))
But I can't use A:A200 since any column has always data.Any Help ?
ps: I do not want to use/add one more Column to update the above formula
J5= rand() and then:
=SUMPRODUCT(SUBTOTAL(3,OFFSET(j5:j200,ROW(j5:j200)-ROW(j5),,1)),--(D5:D200=""))
I would like to use references to just one Column the Column D