Hi there,
I have a very big problem. I am currently doing an invoicing system. The excel spreadsheet looks as below.
client|add|late|mon|tue|wed|thu|fri|sat|sun|hours|charge
visit
||||
MONDAY TO SUNDAY columns are sub divided into theree columns (for morning, lunch and evening sessions).
At the moment late visits are entered in a seperate row , if there is a late visit it crosses the late visit column and the relevant time length is entered in the last sub column of the each day column. and the charge rate is calculated by using following excel function.
=IF(E9="x",(COUNTIF(F9:T9,0.5)-AG9),0)
but what i have to do now is to not having a seperate row to this late visits and to check only the late visit columns. but i cannot specify the same range cause above range consists of the whole row. it has to be last sub column of each day column. is there any way that i can do it?
I really appriciate u r help
Thank you very much for u r help in advance.
Sanjna...
I have a very big problem. I am currently doing an invoicing system. The excel spreadsheet looks as below.
client|add|late|mon|tue|wed|thu|fri|sat|sun|hours|charge
visit
||||
MONDAY TO SUNDAY columns are sub divided into theree columns (for morning, lunch and evening sessions).
At the moment late visits are entered in a seperate row , if there is a late visit it crosses the late visit column and the relevant time length is entered in the last sub column of the each day column. and the charge rate is calculated by using following excel function.
=IF(E9="x",(COUNTIF(F9:T9,0.5)-AG9),0)
but what i have to do now is to not having a seperate row to this late visits and to check only the late visit columns. but i cannot specify the same range cause above range consists of the whole row. it has to be last sub column of each day column. is there any way that i can do it?
I really appriciate u r help
Thank you very much for u r help in advance.
Sanjna...
