countif, issues with ranges shifting

P

paterry2006

New Member
Joined
Sep 15, 2016
Messages
2
I am trying to use the countif function to gather data, I have a large number of columns that will
need to have the countif function. As illustrated when I try to copy the functions across row or columns the range shifts. I tried both copy and paste as well as dragging the functions but neither method works. I can manually enter countif for each column but will be time consuming.
Help

[TABLE="width: 603"]
<tbody>[TR]
[TD="class: xl65, width: 89, bgcolor: transparent"][/TD]
[TD="class: xl65, width: 89, bgcolor: transparent"]A
[/TD]
[TD="class: xl65, width: 89, bgcolor: transparent"]B
[/TD]
[TD="class: xl65, width: 89, bgcolor: transparent"]C
[/TD]
[TD="class: xl65, width: 89, bgcolor: transparent"]D
[/TD]
[TD="class: xl65, width: 89, bgcolor: transparent"]E
[/TD]
[TD="class: xl65, width: 89, bgcolor: transparent"]F
[/TD]
[TD="class: xl65, width: 89, bgcolor: transparent"][/TD]
[TD="class: xl65, width: 89, bgcolor: transparent"]


[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"]Monday
[/TD]
[TD="class: xl67, bgcolor: transparent"]Tuesday
[/TD]
[TD="class: xl67, bgcolor: transparent"]Wednesday
[/TD]
[TD="class: xl67, bgcolor: transparent"]Thursday
[/TD]
[TD="class: xl67, bgcolor: transparent"]Friday
[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl69, width: 89, bgcolor: transparent"] "ANDREW"
[/TD]
[TD="class: xl76, bgcolor: #CCC0DA"]Tuan
[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]Tuan
[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]Tuan
[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]Tuan
[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]Tuan
[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]Aaron
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]2
[/TD]
[TD="class: xl70, width: 89, bgcolor: #D9D9D9"]"KATRINA"

[/TD]
[TD="class: xl76, bgcolor: #CCC0DA"][/TD]
[TD="class: xl68, bgcolor: white"]Darcy
[/TD]
[TD="class: xl68, bgcolor: white"]Darcy
[/TD]
[TD="class: xl68, bgcolor: white"][/TD]
[TD="class: xl68, bgcolor: white"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]Allon
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]3
[/TD]
[TD="class: xl71, width: 89, bgcolor: white"]"TEDDY"

[/TD]
[TD="class: xl76, bgcolor: #CCC0DA"]Lisa
[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]Lisa
[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]Lisa
[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]Lisa
[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]Lisa
[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]Andrew
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]4
[/TD]
[TD="class: xl70, width: 89, bgcolor: #D9D9D9"]"THOR"

[/TD]
[TD="class: xl76, bgcolor: #CCC0DA"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]Bjorn
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]5
[/TD]
[TD="class: xl69, width: 89, bgcolor: transparent"]"SANDY"

[/TD]
[TD="class: xl76, bgcolor: #CCC0DA"]Allen
[/TD]
[TD="class: xl72, bgcolor: #D9D9D9"]Allen
[/TD]
[TD="class: xl72, bgcolor: #D9D9D9"]Allen
[/TD]
[TD="class: xl72, bgcolor: #D9D9D9"]Allen
[/TD]
[TD="class: xl72, bgcolor: #D9D9D9"]Allen
[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]Blake
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]6
[/TD]
[TD="class: xl70, width: 89, bgcolor: #D9D9D9"]"TRON"

[/TD]
[TD="class: xl76, bgcolor: #CCC0DA"]Ronald
[/TD]
[TD="class: xl74, bgcolor: #CCC0DA"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl67, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]Bret S
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]7
[/TD]
[TD="class: xl69, width: 89, bgcolor: transparent"]167 "JOE"

[/TD]
[TD="class: xl76, bgcolor: #CCC0DA"][/TD]
[TD="class: xl74, bgcolor: #CCC0DA"][/TD]
[TD="class: xl66, bgcolor: #D9D9D9"][/TD]
[TD="class: xl66, bgcolor: #D9D9D9"][/TD]
[TD="class: xl66, bgcolor: #D9D9D9"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]Brett R
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]8
[/TD]
[TD="class: xl70, width: 89, bgcolor: #D9D9D9"]"HECTOR"

[/TD]
[TD="class: xl76, bgcolor: #CCC0DA"]Blake
[/TD]
[TD="class: xl74, bgcolor: #CCC0DA"]Blake
[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]Blake
[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]Blake
[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]Blake
[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]Cassie
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]9
[/TD]
[TD="class: xl69, width: 89, bgcolor: transparent"]"TEX"

[/TD]
[TD="class: xl77, bgcolor: #CCC0DA"][/TD]
[TD="class: xl75, bgcolor: #CCC0DA"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]Corey
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]10[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: left"]
<v:shapetype id="_x0000_t75" stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" o:preferrelative="t" o:spt="75" coordsize="21600,21600"><v:stroke joinstyle="miter"><v:formulas><v:f eqn="if lineDrawn pixelLineWidth 0"><v:f eqn="sum @0 1 0"><v:f eqn="sum 0 0 @1"><v:f eqn="prod @2 1 2"><v:f eqn="prod @3 21600 pixelWidth"><v:f eqn="prod @3 21600 pixelHeight"><v:f eqn="sum @0 0 1"><v:f eqn="prod @6 1 2"><v:f eqn="prod @7 21600 pixelWidth"><v:f eqn="sum @8 21600 0"><v:f eqn="prod @7 21600 pixelHeight"><v:f eqn="sum @10 21600 0"></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:formulas><v:path o:connecttype="rect" gradientshapeok="t" o:extrusionok="f"><o:lock aspectratio="t" v:ext="edit"></o:lock></v:path></v:stroke></v:shapetype>

<tbody>
[TD="class: xl65"][/TD]

</tbody>
[/TD]
[TD="class: xl75, bgcolor: #CCC0DA"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]Craig L
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]11[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl75, bgcolor: #CCC0DA"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]Dan R
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]12[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: #CCC0DA"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]Darcy
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]13[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: #CCC0DA"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]Eldon
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]14[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: #CCC0DA"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]Joe
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]15[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: left"]

<tbody>
[TD="class: xl65"][/TD]

</tbody>
[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]Justin H
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]16[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl73, bgcolor: transparent, align: right"]1
[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]Kurt
[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"]Kyle
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Lisa
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Paul T
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Ronald
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Ryan
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Steven
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Tuan
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Uyen
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Ward
[/TD]
[/TR]
</tbody>[/TABLE]










[TABLE="width: 603"]
<colgroup><col width="89" style="width: 67pt; mso-width-source: userset; mso-width-alt: 3254;" span="9"> <tbody>[TR]
[TD="class: xl65, width: 89, bgcolor: transparent"] [/TD]
[TD="class: xl65, width: 89, bgcolor: transparent"]A[/TD]
[TD="class: xl65, width: 89, bgcolor: transparent"]B[/TD]
[TD="class: xl65, width: 89, bgcolor: transparent"]C[/TD]
[TD="class: xl65, width: 89, bgcolor: transparent"]D[/TD]
[TD="class: xl65, width: 89, bgcolor: transparent"]E[/TD]
[TD="class: xl65, width: 89, bgcolor: transparent"]F[/TD]
[TD="class: xl65, width: 89, bgcolor: transparent"] [/TD]
[TD="class: xl65, width: 89, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"]Monday[/TD]
[TD="class: xl67, bgcolor: transparent"]Tuesday[/TD]
[TD="class: xl67, bgcolor: transparent"]Wednesday[/TD]
[TD="class: xl67, bgcolor: transparent"]Thursday[/TD]
[TD="class: xl67, bgcolor: transparent"]Friday[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl69, width: 89, bgcolor: transparent"]
"ANDREW"[/TD]
[TD="class: xl76, bgcolor: #CCC0DA"]Tuan[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]Tuan[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]Tuan[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]Tuan[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]Tuan[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]Aaron[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]2[/TD]
[TD="class: xl70, width: 89, bgcolor: #D9D9D9"]"KATRINA"
 [/TD]
[TD="class: xl76, bgcolor: #CCC0DA"] [/TD]
[TD="class: xl68, bgcolor: white"]Darcy[/TD]
[TD="class: xl68, bgcolor: white"]Darcy[/TD]
[TD="class: xl68, bgcolor: white"] [/TD]
[TD="class: xl68, bgcolor: white"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]Allon[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]3[/TD]
[TD="class: xl71, width: 89, bgcolor: white"]"TEDDY"
 [/TD]
[TD="class: xl76, bgcolor: #CCC0DA"]Lisa[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]Lisa[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]Lisa[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]Lisa[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]Lisa[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]Andrew[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]4[/TD]
[TD="class: xl70, width: 89, bgcolor: #D9D9D9"]"THOR"
 [/TD]
[TD="class: xl76, bgcolor: #CCC0DA"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]Bjorn[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]5[/TD]
[TD="class: xl69, width: 89, bgcolor: transparent"]"SANDY"
 [/TD]
[TD="class: xl76, bgcolor: #CCC0DA"]Allen[/TD]
[TD="class: xl72, bgcolor: #D9D9D9"]Allen[/TD]
[TD="class: xl72, bgcolor: #D9D9D9"]Allen[/TD]
[TD="class: xl72, bgcolor: #D9D9D9"]Allen[/TD]
[TD="class: xl72, bgcolor: #D9D9D9"]Allen[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]Blake[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]6[/TD]
[TD="class: xl70, width: 89, bgcolor: #D9D9D9"]"TRON"
 [/TD]
[TD="class: xl76, bgcolor: #CCC0DA"]Ronald[/TD]
[TD="class: xl74, bgcolor: #CCC0DA"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]Bret S[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]7[/TD]
[TD="class: xl69, width: 89, bgcolor: transparent"]167 "JOE"
[/TD]
[TD="class: xl76, bgcolor: #CCC0DA"] [/TD]
[TD="class: xl74, bgcolor: #CCC0DA"] [/TD]
[TD="class: xl66, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl66, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl66, bgcolor: #D9D9D9"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]Brett R[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]8[/TD]
[TD="class: xl70, width: 89, bgcolor: #D9D9D9"]"HECTOR"
 [/TD]
[TD="class: xl76, bgcolor: #CCC0DA"]Blake[/TD]
[TD="class: xl74, bgcolor: #CCC0DA"]Blake[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]Blake[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]Blake[/TD]
[TD="class: xl66, bgcolor: #D9D9D9"]Blake[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]Cassie[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent, align: right"]9[/TD]
[TD="class: xl69, width: 89, bgcolor: transparent"]"TEX"
 [/TD]
[TD="class: xl77, bgcolor: #CCC0DA"] [/TD]
[TD="class: xl75, bgcolor: #CCC0DA"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]Corey[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] 10[/TD]
​
[TD="class: xl65, bgcolor: transparent, align: center"] [/TD]
​
[TD="bgcolor: transparent, align: left"]
<v:shapetype id="_x0000_t75" stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" o:preferrelative="t" o:spt="75" coordsize="21600,21600"> <v:stroke joinstyle="miter"> <v:formulas> <v:f eqn="if lineDrawn pixelLineWidth 0"> <v:f eqn="sum @0 1 0"> <v:f eqn="sum 0 0 @1"> <v:f eqn="prod @2 1 2"> <v:f eqn="prod @3 21600 pixelWidth"> <v:f eqn="prod @3 21600 pixelHeight"> <v:f eqn="sum @0 0 1"> <v:f eqn="prod @6 1 2"> <v:f eqn="prod @7 21600 pixelWidth"> <v:f eqn="sum @8 21600 0"> <v:f eqn="prod @7 21600 pixelHeight"> <v:f eqn="sum @10 21600 0"> </v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:formulas> <v:path o:connecttype="rect" gradientshapeok="t" o:extrusionok="f"> <o:lock aspectratio="t" v:ext="edit"> </o:lock></v:path></v:stroke></v:shapetype>​
​
<tbody>
​
[TD="class: xl65, width: 89, bgcolor: transparent, align: center"] [/TD]
​
​
</tbody>
​
[/TD]
​
[TD="class: xl75, bgcolor: #CCC0DA, align: center"] [/TD]
​
[TD="class: xl65, bgcolor: transparent, align: center"] [/TD]
​
[TD="class: xl65, bgcolor: transparent, align: center"] [/TD]
​
[TD="class: xl65, bgcolor: transparent, align: center"] [/TD]
​
[TD="class: xl65, bgcolor: transparent, align: center"] [/TD]
​
[TD="class: xl65, bgcolor: transparent, align: center"]Craig L[/TD]
​
[/TR]
​
[TR]
​
[TD="class: xl65, bgcolor: transparent, align: center"] 11[/TD]
​
[TD="class: xl65, bgcolor: transparent, align: center"] [/TD]
​
[TD="class: xl73, bgcolor: transparent, align: center"]1[/TD]
​
[TD="class: xl75, bgcolor: #CCC0DA, align: center"] [/TD]
​
[TD="class: xl65, bgcolor: transparent, align: center"] [/TD]
​
[TD="class: xl65, bgcolor: transparent, align: center"] [/TD]
​
[TD="class: xl65, bgcolor: transparent, align: center"] [/TD]
​
[TD="class: xl65, bgcolor: transparent, align: center"] [/TD]
​
[TD="class: xl65, bgcolor: transparent, align: center"]Dan R[/TD]
​
[/TR]
​
[TR]
​
[TD="class: xl65, bgcolor: transparent, align: center"] 12[/TD]
​
[TD="class: xl65, bgcolor: transparent, align: center"] [/TD]
​
[TD="class: xl65, bgcolor: transparent, align: center"] [/TD]
​
[TD="class: xl75, bgcolor: #CCC0DA, align: center"] [/TD]
​
[TD="class: xl65, bgcolor: transparent, align: center"] [/TD]
​
[TD="class: xl65, bgcolor: transparent, align: center"] [/TD]
​
[TD="class: xl65, bgcolor: transparent, align: center"] [/TD]
​
[TD="class: xl65, bgcolor: transparent, align: center"] [/TD]
​
[TD="class: xl65, bgcolor: transparent, align: center"]Darcy[/TD]
​
[/TR]
​
[TR]
​
[TD="class: xl65, bgcolor: transparent, align: center"] 13[/TD]
​
[TD="class: xl65, bgcolor: transparent, align: center"] [/TD]
​
[TD="class: xl65, bgcolor: transparent, align: center"] [/TD]
​
[TD="class: xl75, bgcolor: #CCC0DA, align: center"] [/TD]
​
[TD="class: xl65, bgcolor: transparent, align: center"] [/TD]
​
[TD="class: xl65, bgcolor: transparent, align: center"] [/TD]
​
[TD="class: xl65, bgcolor: transparent, align: center"] [/TD]
​
[TD="class: xl65, bgcolor: transparent, align: center"] [/TD]
​
[TD="class: xl65, bgcolor: transparent, align: center"]Eldon[/TD]
​
[/TR]
​
[TR]
​
[TD="class: xl65, bgcolor: transparent, align: center"] 14[/TD]
​
[TD="class: xl65, bgcolor: transparent, align: center"] [/TD]
​
[TD="class: xl65, bgcolor: transparent, align: center"] [/TD]
​
[TD="class: xl75, bgcolor: #CCC0DA, align: center"] [/TD]
​
[TD="class: xl65, bgcolor: transparent, align: center"] [/TD]
​
[TD="class: xl65, bgcolor: transparent, align: center"] [/TD]
​
[TD="class: xl65, bgcolor: transparent, align: center"] [/TD]
​
[TD="class: xl65, bgcolor: transparent, align: center"] [/TD]
​
[TD="class: xl65, bgcolor: transparent, align: center"]Joe[/TD]
​
[/TR]
​
[TR]
​
[TD="class: xl65, bgcolor: transparent, align: center"] 15[/TD]
​
[TD="class: xl65, bgcolor: transparent, align: center"] [/TD]
​
[TD="class: xl65, bgcolor: transparent, align: center"] [/TD]
​
[TD="bgcolor: transparent, align: left"]
​
​
<tbody>
​
[TD="class: xl65, width: 89, bgcolor: transparent, align: center"] [/TD]
​
​
</tbody>
​
[/TD]
​
[TD="class: xl65, bgcolor: transparent, align: center"] [/TD]
​
[TD="class: xl65, bgcolor: transparent, align: center"] [/TD]
​
[TD="class: xl65, bgcolor: transparent, align: center"] [/TD]
​
[TD="class: xl65, bgcolor: transparent, align: center"] [/TD]
​
[TD="class: xl65, bgcolor: transparent, align: center"]Justin H[/TD]
​
[/TR]
​
[TR]
​
[TD="class: xl65, bgcolor: transparent, align: center"] 16[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl73, bgcolor: transparent, align: right"]1[/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]Kurt[/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl65, bgcolor: transparent"]Kyle[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Lisa[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Paul T[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Ronald[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Ryan[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Steven[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Tuan[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Uyen[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]Ward[/TD]
[/TR]
</tbody>[/TABLE]
 
Sort by date Sort by votes
cant see what you are trying to count

lets see an example countif and then if you copy - what cell you copy to and how you want it to change

so for example
in cell A1 i have =countif( A2:B100, G2)
and when i copy to cell B1 , i want = countif(B2:C100, H2) - (which is what will happen

to stop a cell changing you fix the column or row using a $
 
Upvote 0
Upvote 0
You must log in or register to reply here.

Similar threads

P
  • Question Question
Find the row when a sum on a column with certain values on rows is >= of a value
Replies
7
Views
1K
XOR LX
XOR LX
H
  • Question Question
Vba to change Excel file Properties like Title, Description, Fiscal, Period, file
Replies
0
Views
987
hemant_sonawane
H
S
  • Question Question
Correct Formulas for Mathematical Equations.
Replies
3
Views
859
siash69
S
R
  • Question Question
UserForm help
Replies
2
Views
829
rholdren
R
M
  • Question Question
Counting between 2 worksheets where 1 is filtered.
Replies
0
Views
613
M4rek
M

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top