$$Excel-Macros$$ Re: average from the range with exclusion of one (or more) cells

2009-05-13 Thread Damian
C4:E4 and C7:E7 were taken into average calculation of the C1:E10 range. i hope i put right. i wanted to attach example spreadsheet, but frankly i'm not sure how to do it. Thank you for help Regards Damian On May 10, 4:19 pm, Aindril De wrote: > Hi Damian, > > could you explain the part

$$Excel-Macros$$ average from the range with exclusion of one (or more) cells

2009-05-10 Thread Damian
Hi Everyone, I have a following problem: I have to find the average from the range, say: B2:J10, without taking into account a few cells from that range. Is there any simple formula (vba macro) which calculates it? Thank you Damian