Hi fadeoutagain27

Welcome to the forum.

You say that you want to add values, so just to be clear, when your conditions are met, do you want the cell value to be 2216 or 520+2216 ?

Will the answer always be this 2,216.00 (which, I suppose, is a nice enough figure) or do you nee the facility to change this figure?

You mention "function"; are you expecting a user defined function, or will a bit of VBA be OK ?

Regards
Alastair