=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
|