I have checked that the dates are formatted as dates. The cells are all set as they are supposed to be but I still get 0 as the answer. Here is the command:
=SUMIFS(Table1[Qnt],Table1[Date],">=(2021,10,01)",Table1[Date],"<=(2021,10,31)",Table1[Style No.],"=T1999")
What am I missing? As far as I can tell, this should work.
Thanks for any constructive help.
Bookmarks