[duketter]

Excel 2003 - I am trying to perform a sum for each row (A-Z) that have a cell
highlighted in yellow. So for example, cell A1, D1 and P1 may all be
highlighted in yellow. I want to then perform a sum of the numbers in these
cells only and display it.

Is this possible to sum the data in the cells that are highlighted?

Thanks!

[dlw]

I don't think you can sumif based on the cell format. If there is some
formula or condition that is turning the cells yellow, you can sum on that.

"duketter" wrote:

Excel 2003 - I am trying to perform a sum for each row (A-Z) that have a cell
highlighted in yellow. So for example, cell A1, D1 and P1 may all be
highlighted in yellow. I want to then perform a sum of the numbers in these
cells only and display it.

Is this possible to sum the data in the cells that are highlighted?

Thanks!

[Mike H]

have a look here

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

Mike

"duketter" wrote:

Excel 2003 - I am trying to perform a sum for each row (A-Z) that have a cell
highlighted in yellow. So for example, cell A1, D1 and P1 may all be
highlighted in yellow. I want to then perform a sum of the numbers in these
cells only and display it.

Is this possible to sum the data in the cells that are highlighted?

Thanks!

[Gord Dibben]

If colored by Conditional Formatting, sum based on those conditions.

If manually colored cells you will need VBA function.

See Chip Pearson's site for colorindex functions.

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


Gord Dibben MS Excel MVP

On Tue, 10 Jun 2008 11:35:02 -0700, duketter
wrote:

Excel 2003 - I am trying to perform a sum for each row (A-Z) that have a cell
highlighted in yellow. So for example, cell A1, D1 and P1 may all be
highlighted in yellow. I want to then perform a sum of the numbers in these
cells only and display it.

Is this possible to sum the data in the cells that are highlighted?

Thanks!