Hi Everyone
I am hoping someone will be able to help me with a formula please look at this screenshot link below and then I will explain what I need help with.
http://www.wowserverstatus.com/excel.png
If you notice I have each section labeled with A, B, C and D in green letters, this will make it easier to explain.
Well in table A I have a basic excel calendar which is using the formula from table B. The end result that I am looking for is table C. I would like to use the calendar formula in table B and import another formula into each one of the days to calculate the total number of US sales vs UK sales. The blue numbers next to the day obviously are the US sales for that day and the red numbers are obviously the UK sales for that day.
Now here?s the trick, I would like to make this is auto calculation so if I add data in column D for example 9/21/07 and I sell an $8.00 item in the US column it will auto update the calendar in table C for the date of the 21st to say 1 – 21 – 0.
Another thing if you notice in the calendar in table C is the little << and >> arrows for clicking on and looking at past and future months.
Is anyone up to the challenge of this little project, or can anyone give me some ideas of things I can try to accomplish this goal. I will appreciate anyone?s comments and help you can provide and thank you very much for anything and everything anyone does.
Thanks
Jeff