ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   sum cells depending on color of cell (https://www.excelbanter.com/excel-worksheet-functions/226169-sum-cells-depending-color-cell.html)

Morten

sum cells depending on color of cell
 
I need help on the following problem:

Is there a formula that can SUM if cells are "blue" (or "red") etc? I have
many cells with various background color and I need to sum them depending on
the color of the cell.

Thanks for any help.

Brgds


Gary''s Student

sum cells depending on color of cell
 
See:

http://www.cpearson.com/excel/colors.aspx


--
Gary''s Student - gsnu200842


"Morten" wrote:

I need help on the following problem:

Is there a formula that can SUM if cells are "blue" (or "red") etc? I have
many cells with various background color and I need to sum them depending on
the color of the cell.

Thanks for any help.

Brgds



All times are GMT +1. The time now is 05:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com