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

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

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

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

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

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
---------------
Jacob Skaria


"Jeff" wrote:

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

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

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

"Jeff" wrote:

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