R

#### Randy

Here is a sample of the data:

A B C D E

1 Sample X val Y val Difference Formulas in

Column D

2

IF(A2<>"",B2-C2,"")

3

IF(A3<>"",B3-C3,"")

4

IF(A4<>"",B4-C4,"")

5

IF(A5<>"",B5-C5,"")

6

IF(A2<>"",SUM(ABS(SUMIF(D25,{">0","<0"}))))/COUNT(D25)

Issue: When the table is blank cell D6 has the error #DIV/0!

Question: How can formula in D6 be modified so when table is blank that D6

is also blank

Thank You

Randy