# Excel - COLUMN Function Problem - Expert Solution

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

I would like to add a column by background color, how do I do that?
Solved by C. C. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 26/03/2018 - 09:00
20 min
Excelchat Expert 26/03/2018 - 09:00
hello my name is shah
User 26/03/2018 - 09:01
Hello Shah
User 26/03/2018 - 09:01
I'm Diane
Excelchat Expert 26/03/2018 - 09:01
simply inert column and highlight it
User 26/03/2018 - 09:02
I have inserted the column
User 26/03/2018 - 09:03
I would like to get a total number of either the YES or the backround color
Excelchat Expert 26/03/2018 - 09:03
can you share data
Excelchat Expert 26/03/2018 - 09:04
when yes and when background color?
User 26/03/2018 - 09:04
I have, on the work sheet
User 26/03/2018 - 09:05
I cannot share the complete excel file as it has lots of personal inforamtion
Excelchat Expert 26/03/2018 - 09:06
if you want to calculate total yes simply apply countif function
User 26/03/2018 - 09:06
Can you see the Column that I shared
Excelchat Expert 26/03/2018 - 09:07
yes
User 26/03/2018 - 09:07
I'm not following you
User 26/03/2018 - 09:07
what is the countif function
Excelchat Expert 26/03/2018 - 09:07
countif calculate cell with specfic ceriteria
Excelchat Expert 26/03/2018 - 09:08
and for background conditional formatting
User 26/03/2018 - 09:08
Still not following, I'm really new to excel. can you walk me through how this is done?
Excelchat Expert 26/03/2018 - 09:09
let's see
Excelchat Expert 26/03/2018 - 09:10
if i want to calculate sum of all yes in column i will apply this
Excelchat Expert 26/03/2018 - 09:10
see in worksheet
Excelchat Expert 26/03/2018 - 09:11
cleared
Excelchat Expert 26/03/2018 - 09:12
see cell A105
Excelchat Expert 26/03/2018 - 09:12
are you there?
User 26/03/2018 - 09:13
yes
User 26/03/2018 - 09:13
Thank you
Excelchat Expert 26/03/2018 - 09:14
any objection
User 26/03/2018 - 09:14
That is perfect. Thank you for all you help
Excelchat Expert 26/03/2018 - 09:14

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.