This another one puzzling me!
I have several tanks of sea bass, in excel I have a sheet for each containing various data. This includes the batch number and their growth rate. I want to find out the average growth rate for a given batch number. However not all tanks will neccessarily get stocked with a given batch. If I use the averageif function I more often than not the DIV/0 problem, as there will be a tank or 2 which hasn't been stocked with fish of that particular batch.
Any help would again be much appreciated,
Thanks
Angus
I have several tanks of sea bass, in excel I have a sheet for each containing various data. This includes the batch number and their growth rate. I want to find out the average growth rate for a given batch number. However not all tanks will neccessarily get stocked with a given batch. If I use the averageif function I more often than not the DIV/0 problem, as there will be a tank or 2 which hasn't been stocked with fish of that particular batch.
Any help would again be much appreciated,
Thanks
Angus