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&""))

--
Biff
Microsoft Excel MVP


"Jeff" wrote in message
...
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