Thank you so much for your reply. I really tried your statement but could not get that to work. As another attempt I took your advice and tried several IF statements. Here is my attempt at the four statements but I am having trouble combining them in to one overall statement for one cell in Excel. Again, what I'm try to do is average a set of four averages. The set will not always be the same number of averages to average.

In other words, if the set is one average the I just want to use that average and not try and calculate an average of the remaining three #DIV/0! errors. If it is two averages then I want to average those two averages, and not the other two #DIV/0! errors. If it is three averages then I want to average those three averages, and not the other one #DIV/0! errors.

=IF(C9>0,C9,"")

=IF((AND(C9>0,C11>0)),AVERAGE(C9,C11),C9)

=IF((AND(C9>0,C11>0,C13>0)),AVERAGE(C9,C11,C13),AVERAGE(C9,C11)

=IF((AND(C9>0,C11>0,C13>0,C15>0)),AVERAGE(C9,C11,C13,C15),AVERAGE(C9,C11,C13)))

THANK YOU!

## Bookmarks