| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
merge affecting dsum calculation
Is there anyway to make a merged cell behave like the cells it has replaced? I am running a dsum calculation on a table similar to the one below and whilst it works ok when i search by field1=7 and field2=100 it doesnt work when i run field1=7 and field2=140 (field 1 is a merged cell 3 rows deep). Is there anyway to make the merged cell cover all three rows (other than entering 7 into each row and then hiding the lower 7s and using outline etc to make the cells appear as tho merged)? Formula: -------------------- field1 | field 2 | field3 7 | 100 | 25 | 140 | 20 | 180 | 18 -------------------- many thanks mxp -- mxp ------------------------------------------------------------------------ mxp's Profile: http://www.excelforum.com/member.php...o&userid=30994 View this thread: http://www.excelforum.com/showthread...hreadid=508787 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Difficult for me, probably basic to you | Excel Worksheet Functions | |||
| Word found no merge fields in your main document. | Excel Discussion (Misc queries) | |||
| Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
| Different graphic for each record in mail merge document | Charts and Charting in Excel | |||
| How do I do an excel merge like a word mailmerge with another exc. | Excel Discussion (Misc queries) | |||
Threaded Mode
