I agree but in this case I'm not in position to make such a decision. I was
just asked to provide a solution.

Oscar.

"David Biddulph" wrote:

Standard advice here is *not* to merge cells.
--
David Biddulph

"Oscar" wrote in message
...
How can I use the sumif [=SUMIF(A1:A3;D1;B1:B3)] if A1 and A2 are merged
and
I want value from merged cell to be valid for both A1 and A2?

Oscar