# Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I have a formula in Column G: =COUNTIF(B19:B38, "M") and I want to copy it to Column J, but I want it to say =COUNTIF(C19:C38, "M"), NOT =COUNTIF(E19:E38, "M"). Is there an easy way to do this? I have a whole spreadsheet to do.
Solved by V. S. in 8 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 20/06/2018 - 02:45
HI
Excelchat Expert 20/06/2018 - 02:46
Welcoem to got i tpro!
User 20/06/2018 - 02:46
Hello, thank you!
Excelchat Expert 20/06/2018 - 02:47
COUNTIF(B19:B38, "M")
Excelchat Expert 20/06/2018 - 02:47
For your question, the best way to do this is to change it manually
Excelchat Expert 20/06/2018 - 02:48
for example,B19:B38,
Excelchat Expert 20/06/2018 - 02:48
You can change this part to the column that you need
Excelchat Expert 20/06/2018 - 02:48
And this is the best/fastest way to do it
User 20/06/2018 - 02:49
that's what I was afraid of. That's what I've been doing, I just have over 100 places I need to do this. I was hoping there was a better solution
Excelchat Expert 20/06/2018 - 02:50
Unless you could line other the column that you need at the first place
Excelchat Expert 20/06/2018 - 02:50
for example, when you switch the column, the next column is always be the column you want to search for
Excelchat Expert 20/06/2018 - 02:51
If you need to specify very specific columns, then you need to change them one by one
User 20/06/2018 - 02:51
alright, well thank you, I appreciate your time. i figured it was a long shot, but you never know.
Excelchat Expert 20/06/2018 - 02:52
We do hope that this solved your question but due to the nature of your problem there are the only 2 way to solve it
User 20/06/2018 - 02:53
not a problem, thank you so much
Excelchat Expert 20/06/2018 - 02:54
Well, hope you have a great night !
User 20/06/2018 - 02:54
you too!

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.