Do Array Formulas have to be populated!?

[genepaton]

Hi All,

I've written a couple of formulas for calculating averages in excel 2003 based on multiple criteria, but as the data is changing and sometimes not populated at all in these rows, its spitting out a #DIV/0! error.

Do Array Formula's require at least one cell populated?

And if so, is there a work around for this?

I need for it to populate a "0" answer if there is no data for it to work off.

Example formula:

{=AVERAGE(IF((Sheet1!B2:B65536="2")*(Sheet1!L2:L65536<>0),Sheet1!L2:L65536))/1440}

I tried working around it by including the second condition that the entry must be greater than 0, thinking that excel counted the blank cells as 0 value.

FYI Im working with time values in minutes, hence the /1440 and formatting the cell to hh:mm

 

[T. Valko]

Hey T Valko,

I tried to PM you but you're not accepting, anyway we can get in touch?

Well, I have PMs turned off because I was getting way too many requests for private help!

 

[genepaton]

Well, I have PMs turned off because I was getting way too many requests for private help!

****... There goes that idea

 

[T. Valko]

****... There goes that idea

You're better off posting to the forum.

Your post gets seen by many more people plus, I may not know how to do what you want to do!

 

[genepaton]

You're better off posting to the forum.

Your post gets seen by many more people plus, I may not know how to do what you want to do!

I was actually just after someone to 'proof read' through the work i've already done, and give some feedback on possible areas that may go wrong or suggestions. The project im working on is a little outside the norm for excel.
Got 10 min to spare?