请教：Excel表，如何自动增加行数，保持与上行单元格的公式和格式向下复制

media000

请教：Excel表，如何自动增加行数，保持与上行单元格的公式和格式向下复制?

例如：
第一行的格式是这样的：
=COUNTIFS(Created!N2:N58,I9,Created!P258,O1)

期望第二行的数据是这样的结果
=COUNTIFS(Created!N2:N58,I10,Created!P258,O1)

期望第三行的数据是这样的结果
=COUNTIFS(Created!N2:N58,I11,Created!P258,O1)

有什么方法可以让每增加一行，数值的显示都可以自动遵循这个方法？谢谢。

[ 本帖最后由 media000 于 23-3-2009 14:16 编辑 ]

media000

Answer LD's question as following:

That will be very easy.
you can:
1.Select the area first.
2.click Data->List->create list
3.If the area has already got title, you can tick 'my list has title already', if not you can specify one by yourself.
4. then, you make sure every line in your list has the fomula enter.
5. When you insert a new line in the list, the number in the formula will be updated automatically.

Please refer to the attached excel. Field 'TT' is the fomular/function. You can try to append a new line inside the list, the fomular will change by itself automatically.
Excel_sample_1.zip (2.65 KB, 下载次数: 12)

23-3-2009 13:28 上传

点击文件名下载附件

[ 本帖最后由 media000 于 23-3-2009 14:29 编辑 ]

hidec

this couple

fishyoyo

Try  =COUNTIFS(Created!$N$2: $N$58,I9,Created!$P$2: $P$58,$O1)

Please remove the space between the formula.

[ 本帖最后由 fishyoyo 于 23-3-2009 15:41 编辑 ]