formula to add a 1 or 0 depending on cell colour

[me1992]

Good day

I need help with a formula

the formula must calculate if a 1 or 0 is entered into a yellow or green block and display in the block provided for yellow and green colors, the formula must add all the 1 in all the yellow blocks and all the 1's in the green blocks see attached

Thanks
Megan

[ChemistB]

Excel formulas do not see color. You could use VBA to make a User Defined Function or you could use SUBTOTAL combined with Filter (Excel can filter or sort colors from 2007 up)

So
=SUBTOTAL(9,$B$2:$B$16)
Then filter on yellow cells will give you Operations value (enter it in)
Filtr on Green to give Plant value
Hope that helps

[me1992]

Thank you I will try that

[FDibbins]

As an alternative, is there a rule or some logic as to why some 's will be green and others yellow? If so, you could use countif() or countifS() based on that to count them?

[me1992]

this is a type of audit so the site will be scored a 1 or a 0 so the yellow cells are seperate calculations from the green so each color needsto be calculated seperately

[FDibbins]

could you devise a slightly different scoring method that will differentiate 1 from the other? yellow = A, green = 1?