| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumif merged cells
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sumif merged cells
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sumif merged cells
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sumif merged cells
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" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sumif merged cells
Unfortunately there are more than 3 lines involved and more than 1 merged
area in column A (A1:A3, A5:A8, ...). "Roger Govier" wrote: 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" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Autofit Merged cell Code is changing the format of my merged cells | Excel Discussion (Misc queries) | |||
| Cells are Merged. How to know where to where??? | New Users to Excel | |||
| how do i link merged cells to a merged cell in another worksheet. | Excel Worksheet Functions | |||
| Merged Cells | Excel Discussion (Misc queries) | |||
| Sorting merged cellsHow do I sort merged cells not identically siz | Excel Worksheet Functions | |||
Linear Mode
