Sumif merged cells

O

Oscar

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
 
O

Oscar

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 said:
Standard advice here is *not* to merge cells.
--
David Biddulph

Oscar said:
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
Click to expand...
Click to expand...
 
R

Roger Govier

Hi Oscar

Assuming there are no other blanks in the range, then
=SUMIF(A1:A3,D1,B1:B3)+SUMIF(A1:A3,"",B1:B3)

--
Regards
Roger Govier

Oscar said:
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 said:
Standard advice here is *not* to merge cells.
--
David Biddulph

Oscar said:
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
Click to expand...
Click to expand...
Click to expand...
 
O

Oscar

Unfortunately there are more than 3 lines involved and more than 1 merged
area in column A (A1:A3, A5:A8, ...).

Roger Govier said:
Hi Oscar

Assuming there are no other blanks in the range, then
=SUMIF(A1:A3,D1,B1:B3)+SUMIF(A1:A3,"",B1:B3)

--
Regards
Roger Govier

Oscar said:
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 said:
Standard advice here is *not* to merge cells.
--
David Biddulph

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
Click to expand...
Click to expand...
Click to expand...
 
Top