There is a detailed explanation at
http://xldynamic.com/source/xld.SUMPRODUCT.html

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
wrote in message
ups.com...
Thank you very much Richard. Your method works great! Just wonder how
you did that, where I can find more information if I want to learn more
about things like this?

Thanks again.

Julia


RichardSchollar wrote:
You could use:

=SUMPRODUCT(--(TEXT(A1:A1000,"dddd")="Monday"))

to count how many Mondays there are in cells A1:A1000. The criteria
can be a cell reference (ie a cell containing Monday, or Tuesday,
etc...). Adjust your range to suit.

Hope this helps!

Richard