exceL NOOB needs help w/sales tracking

  • Thread starter Thread starter DIXIEDH
  • Start date Start date
D

DIXIEDH

I manage a nightclub and want to create a sales tracking chart pe
server. This is easy if all servers occupied the same cells on ever
worksheet. However, corporate insists that the daily sales report b
designed around stations. Therefore, my servers rotate from station t
station on a daily basis. I know i could always make a seperat
worksheet designed around the servers and input the server totals
second time onto that worksheet but i was hoping of finding someway o
linking a second worksheet that totals up the sales per server as
enter them into the daily sales report (the one designed aroun
stations).

Any ideas?
 
Dixie, likely, you just need a sumif. And I need a drink!
http://www.officearticles.com/excel/sumif_with_dates_in_microsoft_excel.htm
See the 2nd sumif description. Whether it's dates or whether it's Servers,
no matter. And it doesn't matter if it's on another worksheet. You can have
your server's names in Column B of sheet 1, for instance. Select Column B
and Insert-->Name-->Define and call it SrvrLst; give Column C the name Cash.
Then over on sheet 2, you can do a sumif(SrvrLst,A2,Cash), where A2 contains
the name of one of your servers.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com
 
Back
Top