=SUMPRODUCT((C481:C507<>"")/COUNTIF(C481:C507,C481:C507&""))

[Jeff]

I trying to copy this formula to other cells EXample below:

c1=z
c2=z
c3=g
c4=1



c5 = total count = 3

d5= total

e5-total

What I have to do is change it cell numbers in the formula every time I
paste it in a new cell. I need help

 

[T. Valko]

It's not clear what you're trying to do. Here's my best guess...

Entered in C5 and drag copied across to E5:

=SUMPRODUCT((C1:C4<>"")/COUNTIF(C1:C4,C1:C4&""))

 

[Jacob Skaria]

Use absolute referencing. Below are the different reference styles.

A1 Relative referencing. Both column and row will change if you copy or drag
the formula.
$A1 The column reference is fixed and will not change
A$1 The row reference is fixed and will not change.
$A$1 Column and row reference are fixed.

If this post helps click Yes

 

[Eduardo]

Hi,
If what you mean is that the range is static use

=SUMPRODUCT(($C$481:$C$507<>"")/COUNTIF($C$481:$C$507,$C$481:$C$507&""))