Return blank cell if no value found

[redspanna]

Hi all

NDA.xlsm
	A	B		D	E	F	G		I	J
1
2
3
4	Feb	DATE		TOTAL	PREV +/-		DATE		TOTAL	PREV +/-
5
6		Tue, Feb 01		70	70		Thu, Feb 17		0	0
7		Wed, Feb 02		0	0		Fri, Feb 18		0	-2570
8		Thu, Feb 03		545	545		Sat, Feb 19		0	-95
9		Fri, Feb 04		4695	4695		Sun, Feb 20		0	-1495
10		Sat, Feb 05		0	-950		Mon, Feb 21		0	-1225
11		Sun, Feb 06		140	-335		Tue, Feb 22		0	-475
12		Mon, Feb 07		70	70		Wed, Feb 23		0	0
13		Tue, Feb 08		0	0		Thu, Feb 24		0	-610
14		Wed, Feb 09		950	950		Fri, Feb 25		0	-365
15		Thu, Feb 10		70	-1820		Sat, Feb 26		0	-165
16		Fri, Feb 11		820	-130		Sun, Feb 27		0	-1240
17		Sat, Feb 12		0	-140		Mon, Feb 28		0	-545
18		Sun, Feb 13		0	0				0	0
19		Mon, Feb 14		0	0				0	0
20		Tue, Feb 15		0	0				0	0
21		Wed, Feb 16		0	0				0	0
22
Dashboard (2)

Cell Formulas
Range	Formula
A4	A4	=EOMONTH(TODAY(),-1)+1
D6:D21,I6:I21	D6	=SUMIFS(Data!$F$2:$F$8000,Data!$A$2:$A$8000,DATE(YEAR(TODAY()),MONTH(TODAY()),C6))
E6:E21	E6	=D6-Pivots!F2
J6:J21	J6	=I6-Pivots!F18
F12	F12	=IF(A10="","",IF(MONTH(A10+1)<>MONTH(A10),"",A10))
B6	B6	=IF($A$4="","",IF(MONTH($A$4+1)<>MONTH($A$4),"",$A$4))
B7:B21,G7:G21	B7	=IF(B6="","",IF(MONTH(B6+1)<>MONTH(B6),"",B6+1))
G6	G6	=IF(B21="","",IF(MONTH(B21+1)<>MONTH(B21),"",B21+1))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
J6:J21	Other Type	Icon set		NO
E6:E21	Other Type	Icon set		NO

So with above example data, how can I change the formula in thru column I so that if the formula thru column G returns a BLANK value, then the value in column I is also BLANK
At the moment as you can see if any value in column G is BLANK a zero (0) is shown in column I - I'd like this to be blank

Thanks in advance

 

[Fluff]

How about

=IF(G6="","",SUMIFS(Data!$F$2:$F$8000,Data!$A$2:$A$8000,DATE(YEAR(TODAY()),MONTH(TODAY()),H6)))

 

[redspanna]

How about

=IF(G6="","",SUMIFS(Data!$F$2:$F$8000,Data!$A$2:$A$8000,DATE(YEAR(TODAY()),MONTH(TODAY()),H6)))

@Fluff
Perferct - thank you

 

[Fluff]

You're welcome & thanks for the feedback.