First of all, i am quite new to excel (been using it for two weeks now), and i am creating a template, where i can put some data in and it calculates and so on. It's going really well except that in some situations keep running into the #division/0! error.

My formula looks like this:
=MIDDEL.HVISER('1'!H96:H160;'1'!F96:F160;">21";'1'!H96:H160;">0";'1'!F96:F160;"<6";'1'!F96:F160;">0")

Middel.hviser() is the danish equal to average.if.

as you can see i have written that the data has to be >0 in both columns. And thats why it puzzles me that #division/0 keeps returning.

sorry if this is a little hard to understand, as i am new to excel, my way around the right terms is a little hard.

Thanks
Kristoffer