On Sat, 28 Jan 2006 12:44:27 -0800, Thomas
wrote:

I am trying to sum items by weekday from date. My list has dates and items
recieved. I would like to total all items received on Mondays, then all
items Tuesdays etc. Sorting is not an option since I looking up the
information on a different sheet based on the criteria that it is what day of
the week? Any sugestions?


=SUMPRODUCT((WEEKDAY(date_rng)=DOW)*(item_rcvd_rng ))

For DOW

1=Sunday
2=Monday
3=Tuesday
etc.

Make sure your two ranges (*_rng) in the formula are the same size.


--ron