CountIFs <> not working (small example)

[ItalianPlatinum]

I have a very large data set, thousands of rows. I parsed it down easily for handling/testing. But even with a small example I cannot get the result I desire. I am trying to pull a condition where if a date in general format i.e. 20221216 is NOT equal to today to pull. in this example the 5 should present. the range is named YYYYMMDD. What am I doing wrong?

Book1.xlsm
	A	B	C	D	E	F	G	H	I	J
1				Date	20221216
2
3	Account	Unit	amount		Condition		Date	Account	Unit	amount
4	123	A			2		20221216	123	A	2
5							20221219	123	A	5
6
7
Sheet1

Cell Formulas
Range	Formula
E4	E4	=SUMIFS(J$4:J$1048576,A$4:A$1048576,H4,B$4:B$1048576,I4,G$4:G$1048576,"<>YYYYMMDD")

 

[Fluff]

How about

=SUMIFS(J$4:J$1048576,H$4:H$1048576,A4,I$4:I$1048576,B4,G$4:G$1048576,"<>"&E1)

 

[ItalianPlatinum]

Thank you! so the trick was the & and quoting the <> ?

 

[Fluff]

That and changing the columns/criteria.