So column F, H, I, J are all fish weights? With cells that don't have a fish weight either blank or 0.0? So you need to cound how many cells in F,H,I,J have valid data and then sum the total weight and divide by the number of cells with content, is that correct?
Correct, Columns F,
G,H,I,J all have weights entered with the exception of teams that weighed in less than 5 fish. Those places are currently either blank or have an entry of 0.00. Ideally, the calculation would ignore the blanks and 0.00 and output the average weight of all the fish weighed.
A second calculation is needed to count each cell with a number in it an output the total number of fish caught, not the total weight which I already have.
The summation should be: Total Weight of Fish Weighed = already have
Total Number of Fish Weighed =
Average Weight of Fish Weighed=
There were and additional 78 tuna donated but were unweighed. By getting an average of the fish weighed we can extend that out to the additional fish donated to calculate roughly the total weight of all fish turned in, weighed or not, so we have a estimate of the total weight of fish donated to the food bank.
