Does a SUMIF Highlighted formula exist?

[khantler]

Does anyone know of a formula that would sumif the cells in the range are highlighted (basic background highlighting, not conditional formatting)? I'm a pretty basic user and don't know code or VBA. Any help is much appreciated!

Thanks!
Kristin

 

[Oaktree]

Welcome to the board.

There is no embedded way to do this, but Chip Pearson offers up a way to use VBA to create a UDF (user defined function) here:

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

 

[DominicB]

Good evening khantler

If you want to try something via VBA (a custom function) you can get it from here :

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

Alternatively you can download my add-in via the link below which has a number of custom functions for dealing with coloured cells :

=FontColour(A1)
=CellColour(A1)
=SumFontCol(A1:A100,5)
=SumCellCol(A1:A100,10)
=CountFontCol(A1:A100,5)
=CountCellCol(A1:A100,10)

Full instructions are included.

HTH

DominicB