Excel Formula ~ Please

  wee eddie 12:54 01 Aug 2011

I am trying to create a Summary Sheet, within a Spread Sheet, that picks up each Weeks Total Sales from it's Column over several years.

So, I'm looking for a formula that can Auto-fill Sundays' Dates?

Then I will need a formula to connect to that date on a previous or subsequent Work Sheet. I think that I can probably work that one out but it would save me a lot of sweat if someone is able to show me that one as well.

  Housten 17:02 01 Aug 2011

Perhaps I teaching my grandmother how to suck eggs! But if you format the column ( say 'A' )you want to have the dates in then you can type in the first date ( in A1 ) - presumably a Sunday. Then in the cell below ( A2 ) you type "=A2+7", and that will give you the next Sunday. Then copy 'A2' as far down the spreadsheet as you want and all the dates will be Sundays.

About the next bit I am not so sure as I am looking for something similar myself. But I think if you want monthly or annual totals then get the totals added together, once you have done one successfully it's just a copy and paste exercise, and name the cell with the total in it something specific. Then it's just a matter of bringing the totals together, and you won't have to remember exactly which cells because the name will stay with the cell thats doing the totaling. And if you use cell names that reflect the day/date then you will be able to call them from anywhere. So if you were to call the first Sunday this year as "2011WK01", and the second Sunday as "2011WK02" you would be able to see the totals and for which week they represented. Of course if it's months you require that is slightly more complicated but it is still possible.

If I am incorrect I hope someone will correct me, but in the meantime the best of luck!!

  wee eddie 17:23 01 Aug 2011

1st bit done. Many thanks Houston

Second bit is not proving quite as quick a fix as it need to refer to location on another sheet.

  VoG II 17:57 01 Aug 2011

Perhaps VLOOKUP click here

Knowing my look the hyperlink won't work - if so copy this and paste into the address bar


  wee eddie 21:29 01 Aug 2011

Thanks ~ I'll go to work on it.

As Oates said ~ "I shall be away some time."

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

What is ransomware and how do I protect my PC from Petya?

Microsoft Surface Studio – the artist's hands-on review

Original iPhone review

Comment mettre à jour Kodi ?