Countif by Color

[bcally15]

Probably a lay up for someone here but how would I write a countif if formula if criteria was based the color of the cells in my range?
thanks

 

[Mark O'Brien]

Welcome to the board!

I don't believe that you can do what you want with built-in Excel functions, but Dave Hawley at OzGrid has a nice write-up on a VBA solution for your problem:

http://www.ozgrid.com/VBA/Sum.htm

I hope this helps.

 

[bcally15]

Thanks, big help