Serial Number Error in Array Formula

rather then formatting the date as mmmm try to put this in the D column

=TEXT(C3,"mmmm")

Perhaps

=IF($F$3="","",SUMPRODUCT(($A$3:$A$18=$F$3)*($B$3:$B$18=$F6)*(TEXT($D$3:$D$18,"mmmm")=H$4)))

entered in H6

Pull across and down as needed

A Pivot Table would also do the trick

i didnt see pepe's response but that is basicly putting them together

(although you dont need column D ou can just do it with C)

=SUMPRODUCT((--($A$3:$A$18=$F$3)*--($B$3:$B$18=$F8)*--(TEXT($C$3:$C$18,"mmmm")=H$4)))

also insead of your array you could use sumproduct like this

=SUMPRODUCT((--($A$3:$A$18=$F$3)*--($B$3:$B$18=$F8)*--($D$3:$D$18=H$4)))

In fact, SUMPRODUCT, IS an Array formula.

lol true it is but it doesn't need to be entered as an array formula to work

lol true it is but it doesn't need to be entered as an array formula to work

@ twiggywales.

True. But why 2 posts for this?

because my computer hates me, hahaha this it didnt post then suddenly after the second if showed 2

Hmmm. This is not good. Ask for this to explain why does hates you and try to create a nice ralation with it!!

I tried but its giving me the silent treatment