You are here:
Can assist you in most areas of Excel, have been working with it for about 15 years in many types of applications, but primarily in financial and accounting applications. I am a CPA and many client or client problems have necessitated the use of excel. I am not an expert in charting, macros, or pivot tables.
Have been working with Excel for about 15 years primarily in accounting and financial areas.
BA, CPA
Bill I am not sure that I am reading the question correctly but-- You can use data validation to create your list of criteria that go in a cell that is referenced in your count formula. Then when
Eric I am definately not a VBA expert--while I may be able to figure out an answer for you It won't e very quickly, so I suggest you reask the question of another allexperts person and I'm sure you
sree You need linking formulas to bring the data over to the master book. A linking formula will look something like this =[Book1]Sheet1!$A$1 This formula can be in the master book and will bring
Polo Very often the problem with time is the formatting. If I copy your formula to a spreadsheet and format the cells F1 and H1 as 24 hour format, I.E. toolbar/format/cells/time select type of 13:30
Camron Okay I think I understand better now-- I don't have the time to create the calendars for you or think thru all of the formulas that will be necessary, but here is how I would approach it.
Answers by Expert:

©2009 About.com, a part of The New York Times Company. All rights reserved.