Hello,

I need serious help with a couple of formulas.

1st- I am trying to average a row of numbers but need it to not include
numbers in that crtain row if row 7 & 9 are both zeros in that specific
column (I need to do this for rows 7 & 9 - cells G7 & G9). Is there a way to
do this?

2nd- The dollar amounts in row 10 come from other sheets. I would also like
it to only average the amounts if 7 & 9 are not both zeros.


A B C D E
F G
6 Date 12/5/08 12/5/08 12/5/08 12/5/08 12/5/08
Averages
7 Rehab Count 3 4 3 0
0 2.50
8
9 Demo Count 5 7 1 3
0 4.00
10 Costs $670.72 $880.64 $562.35 $539.31 $0.00
$663.25


Thank or any help you can provide!

Scott A