I need help in creating a formula to average data based on conditions
found in neighboring cells. I have data in cells C, I, O, U, AA, & AG.
I need to include each of these cells in the average calculation only
if the cell to its right is greater than zero.

Example:
Cells to average - C=5, I=7, O=9, U=3, AA=5, & AG=77
Neighboring cells - D=19, J=12, P=99, V=108, AB=8, & AH=0
The formula should avarage 5, 7, 9, 3, & 5, for a result of 5.8. 77 is
not included in the average calculation because the cell to its right,
AH, equals zero.

Any suggestions on how this can be done?




Thanks!




Sandi