EXCEL 2007

I have just put up a file for you at:-

http://www.pierrefondes.com/

- item number 82 (towards the top pf my home page at the time of writing).

This gives you what you want: numerical data by days of week.

If my comments have helped please hit Yes.

Thanks.



"Rebecca" wrote:

Hi Everyone,
Hope someone has the answer to this little problem that I can't seem to sort.

I am trying to extract figures from a table. that will allow me to select
all numerical data entered on Mondays or Tuesdays ect

I have a table 365 days long with a column for the date, a column for the
day & a column for collected data.

I wish to extract/collect the sum total of data for the different days of
the week for a whole year.

I have been trying to use the paste function/Lookup facility but cannot fine
anything that gives the sum total of the required info.

--
Thanks Becky