Data collection Sum/Total
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 |
All times are GMT +1. The time now is 12:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com