[SOLVED]Sum cells based on color

[blackshag]

Currently column AO tracks all payments due to venders.
The cells turn brown if those payments are due within 10 days.

See attached .jpg

What would be the appropriate formula so that:

AO74=sum all of the brownish colored cells
It would ignore all other cells.

excel question.jpg

Anyone have any ideas?

[protonLeah]

Attach a sample workbook.

When you are in Advanced reply, click on the paperclip to open the upload window.

View Pic
Also, indicate what conditions color the cells. (Excel vba can't get color indexes and codes from jpg's)

[FDibbins]

if you have a condition that turns the cells brown, you could also use that same conidtion in a sumif() or sumifS() function

[blackshag]

You will find the sample workbook attached.

Thanks!

[FDibbins]

try this...
=SUMIFS(AO50:AO70,AN50:AN70,"<="&TODAY(),AN50:AN70,">="&TODAY()-20)

[blackshag]

Hello FDibbins,
Thank you for your help. I modified the formula to include all of the applicable cells to the formula below:

=SUMIFS(AO7:AO75,AN7:AN75,"<="&TODAY(),AN7:AN75,">="&TODAY()-20)

Unfortunately, this does not compute the sum of the brown cells correctly. Not sure exactly why.

[Kevin UK]

Hi blackshag

Try:

Please Login or Register  to view this content.