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

J

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

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

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
 
E

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel equations 6
Junp start my Select Case Macro 12
Payment calculation 1
#REF! 1
Times 2
Count Number of Unique Cells That Don't Have Certain Characters 0
Adding formula 1
Sumproduct in matrix means 3

Top