Formula that recognises coloured values?

[SRiSport]

Hi All,

Is there a formula that can recognise the colour of a cell value and then calculate only them values?

So for example:

In Column A - I have text which might say 'REBATE' or 'BASIC' from row1-20
In Column B - I have a list of numbers, So if A1 = 'REBATE' the number in B1 changes to red. But if A1 = 'BASIC' the number in B1 stays black

Then in D1 i want to have a formula which calculates all the red values in Column B Row1-20

can this be done?

any help/advise appreciated

regards.

[Jonmo1]

Try

=SUMIF(A1:A20,"Rebate",B1:B20)

[adhawan06]

Try the attachment..

[SRiSport]

Try the attachment..

Thankyou, that works great

[adhawan06]

Glad it worked!!!

and Thanks for adding reputation .