You don't need an array formula, SUMPRODUCT does it
or=SUMPRODUCT(--(WEEKDAY(A1:A100)=2),B1:B100)
=SUMPRODUCT(--(TEXT(A1:A100,"ddd")="Mon"),B1:B100)
You don't need an array formula, SUMPRODUCT does it
or=SUMPRODUCT(--(WEEKDAY(A1:A100)=2),B1:B100)
=SUMPRODUCT(--(TEXT(A1:A100,"ddd")="Mon"),B1:B100)
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Reply With Quote
