ravinder_tig
05-24-2009, 10:36 AM
Hi Guys
I'm quite new to excel programming and i do need your help regarding one of my projects i'm summarizing few sheets to a master worksheet
criteria is bascially month and week based
when i apply average forumla for a month i did get the avg for a month
but when a record for tht month is unfilled
eg weekend is off so no values for that date that displays div/0 error
I want a Macro which cud change this div/0 error in a selected range to be null
so it didn't reflect in avg function on final sheet and gives that value there
I'm attaching a file with this thread
plz don't mind my language
i'm quite new to technical terms
your help would be gr8ly appriciated
Thanks and Regards,
Ravinder S
I'm quite new to excel programming and i do need your help regarding one of my projects i'm summarizing few sheets to a master worksheet
criteria is bascially month and week based
when i apply average forumla for a month i did get the avg for a month
but when a record for tht month is unfilled
eg weekend is off so no values for that date that displays div/0 error
I want a Macro which cud change this div/0 error in a selected range to be null
so it didn't reflect in avg function on final sheet and gives that value there
I'm attaching a file with this thread
plz don't mind my language
i'm quite new to technical terms
your help would be gr8ly appriciated
Thanks and Regards,
Ravinder S