Excel Formula Countif Enhanced

[ItalianPlatinum]

Hello - I am looking for one formula to provide me the count of column C if Column C has blanks The data is provided to me i cannot modify it so I am stuck. See below for a draft. if i incorporate a sum of blanks i get a very large number. My range C:C needs to be dynamic as the data could change from 1,000 rows to one day to 500,000 rows. For example my desired value i want to see in F2 is 20

Book1
	A	B	C	D	E	F	G
1							F
2							1,048,573.00
3	Date	A	V	Name	Type
4	18-Jan	111	F	XXX	xx1
5	18-Jan	222	F	XXX	xx2
6	18-Jan	333	F	XXX	xx3
7	18-Jan	444	F	XXX	xx4
8	18-Jan	555	F	XXX	xx5
9	18-Jan	666	F	XXX	xx6
10	18-Jan	777	F	XXX	xx7
11	18-Jan	888	F	XXX	xx8
12	18-Jan	999	F	XXX	xx9
13	18-Jan	1110	F	XXX	xx10
14	18-Jan	1221	F	XXX	xx11
15	18-Jan	1332	F	XXX	xx12
16	18-Jan	1443	F	XXX	xx13
17	18-Jan	1554	F	XXX	xx14
18	18-Jan	1665	F	XXX	xx15
19	18-Jan	1776	F	XXX	xx16
20	18-Jan	1887	F	XXX	xx17
21	18-Jan	1998		XXX	xx18
22	18-Jan	2109		XXX	xx19
23	18-Jan	2220		XXX	xx20
Sheet1

Cell Formulas
Range	Formula
G2	G2	=COUNTIF(C:C,G1)+COUNTIF(C:C,"")

 

[jtakw]

Hi,

Not sure I understand correctly, is this what you mean:

Book3.xlsx
	A	B	C	D	E	F	G
1							F
2							18
3	Date	A	V	Name	Type
4	1/18/2022	111	F	XXX	xx1
5	1/18/2022	222	F	XXX	xx2
6	1/18/2022	333	F	XXX	xx3
7	1/18/2022	444	F	XXX	xx4
8	1/18/2022	555	F	XXX	xx5
9	1/18/2022	666	F	XXX	xx6
10	1/18/2022	777	F	XXX	xx7
11	1/18/2022	888	F	XXX	xx8
12	1/18/2022	999	F	XXX	xx9
13	1/18/2022	1110	F	XXX	xx10
14	1/18/2022	1221	F	XXX	xx11
15	1/18/2022	1332	F	XXX	xx12
16	1/18/2022	1443	F	XXX	xx13
17	1/18/2022	1554	F	XXX	xx14
18	1/18/2022	1665	F	XXX	xx15
19	1/18/2022	1776	F	XXX	xx16
20	1/18/2022	1887	F	XXX	xx17
21	1/18/2022	1998		XXX	xx18
22	1/18/2022	2109		XXX	xx19
23	1/18/2022	2220		XXX	xx20
Sheet946

Cell Formulas
Range	Formula
G2	G2	=COUNTIF(C:C,G1)+COUNTIFS(A:A,"<>",C:C,"")

 

[ItalianPlatinum]

ah clever i think that could work

 

[jtakw]

Good, if that's not what you need, post back.