Hi,
not sure what you need and example will help however if you have a column
with the 365 days and want to summarize each date with the information
entered in a table where you have in column A the days and in column B the
figures try this
I assume your sheet where with the data is called Table

=sumproduct(--(a1=Table!$A$1:$A$1000),Table!$B$1:$B$1000)

"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