Ignore if cell in colour

[Shakes007]

Hi All,
Column A, As a sum to add all numerical data in that column. If any of the cells in the column are filled with colour, can they be excluded from the sum? Not sure this can be done but I may (hopefully am) wrong.
Thanks

 

[Shakes007]

Or even a SUMIF formula:

Book1
	C	D
1	Nums	Test column
2	£1.00	04/12/2023
3	£5.00	05/12/2023
4	£1.00	06/12/2023
5	£7.00	07/12/2023
6	£1.00	08/12/2023
7	£1.00
8	£1.00
9	£1.00
10	£1.00
11	£1.00
12	£1.00
13	£1.00
14
15	£7.00
Sheet2

Cell Formulas
Range	Formula
C15	C15	=SUMIF(D2:D13,"",C2:C13)

Amazing, you are genius.

I used 1st option and it has worked a treat.
Thank you so much