why showing as blank not zero

[AYSHANA]

my table contains formulas , but why in F4:F8 is showing as blank instead of zero, it should be like E4:E8 or D4:D8.
and also its not calculating, i tried to write the formula again but still im getting same issue.
thank you.

COMBINE vba .xlsm
	B		D	E	F
3			FEB	MAR	APR
4	Received BGRPS		241	0
5	Received XM		58	0
6	Received IAT		1	0
7	Received DAT		0	0
8	Received BGRP		3	0
Summary

Cell Formulas
Range	Formula
D4	D4	=IF($U2<=TODAY(),COUNTIFS('raw daily'!$G$2:$G$3000,">="&$U2,'raw daily'!$G$2:$G$3000,"<="&$U3,'raw daily'!$B$2:$B$3000,$S$4),"")
E4:E8	E4	=IF($V$2<=TODAY(),COUNTIFS('raw daily'!$G$2:$G$3000,">="&$V$2,'raw daily'!$G$2:$G$3000,"<="&$V$3,'raw daily'!$B$2:$B$3000,$S4),"")
F4	F4	=IF($W$2<=TODAY(),COUNTIFS('raw daily'!$G$2:$G$3000,">="&$W$2,'raw daily'!$G$2:$G$3000,"<="&$W$3,'raw daily'!$B$2:$B$3000,$S4),"")
D5	D5	=IF($U2<=TODAY(),COUNTIFS('raw daily'!$G$2:$G$3000,">="&$U2,'raw daily'!$G$2:$G$3000,"<="&$U3,'raw daily'!$B$2:$B$3000,$S$5),"")
F5:F8	F5	=IF($W$2<=TODAY(),COUNTIFS('raw daily'!$G$2:$G$30000,">="&$W$2,'raw daily'!$G$2:$G$30000,"<="&$W$3,'raw daily'!$B$2:$B$30000,$S5),"")
D6	D6	=IF($U2<=TODAY(),COUNTIFS('raw daily'!$G$2:$G$3000,">="&$U2,'raw daily'!$G$2:$G$3000,"<="&$U3,'raw daily'!$B$2:$B$3000,$S$6),"")
D7	D7	=IF($U2<=TODAY(),COUNTIFS('raw daily'!$G$2:$G$3000,">="&$U2,'raw daily'!$G$2:$G$3000,"<="&$U3,'raw daily'!$B$2:$B$3000,$S$7),"")
D8	D8	=IF($U2<=TODAY(),COUNTIFS('raw daily'!$G$2:$G$3000,">="&$U2,'raw daily'!$G$2:$G$3000,"<="&$U3,'raw daily'!$B$2:$B$3000,$S$8),"")

 

[Alex Blakenburg]

You're welcome. Glad @Joe4 and I could help.