Thank you Norie!

Another question...

There's a third column next to column B (obviously), it contains a value in £.

I would like to now make a sum() formula in one cell in another sheet, with conditional formatting like above

If Column A = Y, than account into the sum() formula, if Column = B, then disregard the value.

I tried to tweak if but cannot seem to make it right with the =sum(AND(...))

Am I thinking in the wrong direction?

Thank you!