hi everyone

i have the following problem

i am currently working on an automated invoicing system an i would like to do the following

i have a daily planner for six employees and using a data validation i allocated jobs to each employee for each hour of the day (customers address) each cell is referenced to the date and week number. i had it so that it counted each hour as 1 per customer & employee and totaled up the daily and weekly hours. i now would like to link these to an invoice so that i can automatically invoice the customer on a weekly, fortnightly or four weekly period

i am assuming i need to use either an index & match formula or a countifs
(2007 only???)

this is driving me nuts at the minute so i would really appreciate so urgent assistant

many thanks