mardi 18 juillet 2017

Sumifs function with a criteria as a date to be equal with another date

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