Some times we requires some Special or Customized Functions in Excel but we may not get them.
For Example if you want get Total Values, in a range of Cells, based on the Color of the Cell or Font Color ,
you may not find any specific formula for it.
However VBA at your rescue. You can create a Quick UDF (User defined Function) to get the result they way you want.
Watch this Video to know how to create UDF for Totals based on Cell Color.
After that you can try your own how to created Totals based on Font Color .
and Let me know whether you were able to do or not.