技術(shù) 點(diǎn)
- 技術(shù)
- 點(diǎn)
- V幣
- 點(diǎn)
- 積分
- 1184
|
2#
樓主 |
發(fā)表于 2005-11-28 16:53:00
|
只看該作者
“材料清單2”是用“SUMIF”來(lái)匯總的,可是出了點(diǎn)問(wèn)題:“□120*4”把“□120*80*4”也匯總進(jìn)去了,這個(gè)問(wèn)題該怎么解決??
<TABLE cellSpacing=0 cellPadding=0 width=660 border=0 x:str>
<COLGROUP>
<COL style="WIDTH: 112pt; mso-width-source: userset; mso-width-alt: 4768" width=149>
<COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 1888" width=59>
<COL style="WIDTH: 165pt; mso-width-source: userset; mso-width-alt: 7040" width=220>
<COL style="WIDTH: 23pt; mso-width-source: userset; mso-width-alt: 960" width=30>
<COL style="WIDTH: 107pt; mso-width-source: userset; mso-width-alt: 4576" width=143>
<COL style="WIDTH: 44pt; mso-width-source: userset; mso-width-alt: 1888" width=59>
計(jì)算原稿
材料清單1
項(xiàng)目名稱
工程量
計(jì)算公式
材料規(guī)格
數(shù)量
LT1
-8
0.328
□150*100*4
0.302
2.516*14.982/1000*8
LT2
□100*100*4
0.036
□120*4
0.301
2.625*14.354/1000*8
□120*4
0.670
LT5
□120*80*4
0.986
<TR height=21>
□100*100*4
0.036
0.383*11.842/1000*8
<TD class=xl24><FONT face=宋體 size=2 |
|