Sum if cells match a colour based on conditional formatting

Hey Guys,

Looking for help with totalling a column of where the cells have been changed to a different colour based on their conditional formatting.

• The results need to show in the tab named "strikes", "repeat captain" column.
• The total number needs to come from the tab named "captains", "points" column if coloured red by the conditional formatting.

I took a vba module from a post i had found on a google search, that is within the tab "macro 1" however i'm not sure if that is the way to go...

As always, your help is very much appreciated!

Thanks!

Thank you AlphaFrog, the SumProduct worked perfectly! Really appreciate your support