advanced excel course london - Adding formated cells

Hi Rebecca, many apologies in the delayed reponse!

There is a function in Excel called the Conditional Sum Function, this is an "Add in" and can be found under the Tools menu. It is not loaded in excel by default.

Once it is loaded there are four steps,

1) Identify the range of cells you wish to use
2) Put in the conditions you wish the numbers to be differentiated by, similar to your conditons you have used in your Conditional Formatting.
3) Choose the way you want your results to be displayed
4) Choose a cell or a number of cells you wish your results to be put.

Take a look at that option

Good luck