Get instant live expert help on I need help with excel sum of colored cells

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I 'color fill' some cells on an excel spreadsheet. I want these colored cells to remain colored when I view the excel sheet on the screen, but I don't want these cells colored when I save the sheet as a PDF. Is this possible?
Solved by G. C. in 29 mins
Have multiple sheets with colored cells (with no data contained within them) that I need to be all grouped together on a single sheet. Basically, if I have 3 cells colored on one sheet and 2 colored cells on another, I'd like a third sheet to show all 5 of the colored cells and automatically update as new cells become colored/uncolored.
Solved by B. Q. in 26 mins
I would like to have a total in a column of a number of cells that are colored only(and also have letters and numbers in them). For example in row AI of spread sheet attached, I would like the total of colored cells only and ignore other data not in the colored cells.
Solved by Z. Y. in 24 mins
I need an operation that counts the number of non-colored cells amongst other cells formated to have a slight colored background. The formatting on these cells is such that they are not responsive to colorfunction formulas.
Solved by I. Q. in 28 mins
I need a formula that counts the number of colored cells in a column, regardless of color.
Solved by S. J. in 14 mins