HOW TO COUNT HOW MANY BLANKS and NON BLANKS I HAVE IN MONTH

[AYSHANA]

good day

im trying to count how many blanks and non blanks i have per month

Book1
	A	B	C	D	E	F	G
1	UNIT ALLOCATED IN SYSTEM	UNIT ISSUED IN SYSTEM			2023
2	15-02-23 9:50		WITHOUT BLANK	WITH BLANK		01-01-23	01-02-23
3	15-02-23 14:44		0	0		31-01-23 23:59	28-02-23 23:59
4	15-02-23 14:44	15-02-23 15:41
5	14-02-23 17:38	14-02-23 18:16
6	16-02-23 10:56	16-02-23 11:00
7	15-02-23 23:51	16-02-23 0:02
8	17-02-23 8:58	17-02-23 9:06
9	19-02-23 9:40	19-02-23 13:24
10	19-02-23 9:40
11	19-02-23 5:56
12	18-02-23 19:44
Sheet1

Cell Formulas
Range	Formula
F2	F2	=DATE($E$1,ROWS($F$2:$F$2),ROWS($F$2:$F$2))
G2	G2	=DATE($E$1,ROWS($F$2:$F3),ROWS($F$2:$F$2))
F3:G3	F3	=EOMONTH(F2,0)+"23:59"
C3:D3	C3	=IF($F$2<=TODAY(),COUNTIFS(B2:B12,">="&$U$2,B2:B12,"<"&$F$3,B2:B12,""),"")

 

[awoohaw]

And with SUMPRODUCT you may not need to enter the formula by pressing CTRL+SHIFT+ENTER.

and for accuracy, change this *(--(B2:B12>0))) in cell C3 to *(--($B$2:$B$12>0)))

 

[AYSHANA]

And with SUMPRODUCT you may not need to enter the formula by pressing CTRL+SHIFT+ENTER.

and for accuracy, change this *(--(B2:B12>0))) in cell C3 to *(--($B$2:$B$12>0)))

thank you its working now
can i ask you another question?

 

[awoohaw]

thank you its working now
can i ask you another question?

Yes, but only if related to this topic. Any new topic should be posted as a new question.