Excel 2007 : If certain color then sum=

**50butNifty** · 10-05-2010, 01:24 PM

Hi anyone who can help me!!

I am trying to write a simple formula that will total a sum of only the boxes that are a certain color. This has to be an if formula, as the color of the boxes change according to the status of that account.

Is this possible? I am using Excel 2007

Thank you for any help you can give me!

Pam

**davesexcel** · 10-05-2010, 01:46 PM

This cannot just be done with a formula, formulas work with values, not colors. This can be done with VBA though.

Are the colors made with conditional formatting, or is there a color criteria?

**Marcol** · 10-05-2010, 01:56 PM

If the colours are produced with conditional formatting, then you could possibly use the same formula/criteria.

Otherwise, as Dave says, it's VBa.

**50butNifty** · 10-05-2010, 05:48 PM

Thank you DavesExcel and Marcol. I really don't want to get into VBA with this one. My manager just wanted it for something that is temporary, and he is changing the colors in the cells as he needs to manually.

I was afraid it wasn't possible without VBA.

Appreciate your help though! :-)

**Marcol** · 10-05-2010, 08:12 PM

Google this

Illegitimi non carborundum

This forum will help you in this task.

**zbor** · 10-05-2010, 08:16 PM

Originally Posted by 50butNifty

Thank you DavesExcel and Marcol. I really don't want to get into VBA with this one. My manager just wanted it for something that is temporary, and he is changing the colors in the cells as he needs to manually.

I was afraid it wasn't possible without VBA.

Appreciate your help though! :-)

You can add a filter in first row. Then filter out values by color and use SUBTOTAL function (SUBTOTAL, 109, range)