I want to have in sumifs function, a criteria as a date to be equal with another date. I’ve tried:
=SUMIFS($N11:$AE11,$N11:$AE11,"<>0",$N9:$AE9,"<"&DATE(YEAR(FX11),MONTH(FX11),DAY(FX11)),$N9:$AE9,">"&DATE(YEAR(FX11),MONTH(FX11),DAY(FX11)))
But it seems it doesn’t work. Thanks.
Aucun commentaire:
Enregistrer un commentaire