Sorry, missed that bit

=SUMPRODUCT(--(WEEKDAY(A1:A10)=2),B1:B10)


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

wrote in message
ups.com...
Hi Bob

Sorry I understand where you include the sum of the numbers in
b1:b10???

Thanks