Can someone please help, I spent hours but could not figure it out what were wrong in these formula:


Col S has dates format with different dates & different month values, col Z has this formula =IF(AND(D10="Purple",LEN(C10)>0,LEN(N10)>0),1,"")

I tried to sum all dates in same month of col Z with this formula and got error: =SUMPRODUCT((MONTH($S$7:$S$999)=8)*($Z$9:$Z$999))


can you please help to tell me what wrong with it?