On Jan 6, 9:59*am, "Ragdyer" wrote:
Your parenthesis placed around "3000272.02" are telling the formula to look
for *text* values.

It they're numbers, just remove the parens.

I think you mean quotes or double-quotes.

And of course, you *do know* that your formula is an *array* formula,
and must be entered using CSE.

Good point. But if the OP does not understand how to work with array
formula, it's a good bet that the OP does not know that CSE means ctrl
+shift+Enter.

To the OP: if that might be your problem, select the cell with the
formula, press F2, then press ctrl+shift+Enter.