spreadsheet - 在电子表格上 A :A and ! A :A mean? 是什么

Question

我遇到过这个 sumif 公式，我在 Google 搜索 N:N

时找不到任何帮助

=sumif(N:N,"Cat",C:C)

所以我根据文档理解了 SumIf:

SUMIF(range, criterion, [sum_range])

但是我不完全理解N:N。另外请解释!A:A

谁能提供官方解释或指向文档。

Answer 1

N:N 表示范围包括整个 N 列，而不仅仅是某些单元格(例如 N1:N300)。这允许公式引用列中的所有数据，即使您稍后添加更多行也是如此。

这里解释感叹号:What does an exclamation mark before a cell reference mean?

When entered as the reference of a Named range, it refers to range on the sheet the named range is used on.

For example, create a named range MyName refering to =SUM(!B1:!K1)

Place a formula on Sheet1 =MyName. This will sum Sheet1!B1:K1

Now place the same formula (=MyName) on Sheet2. That formula will sum Sheet2!B1:K1

Note: (as pnuts commented) this and the regular SheetName!B1:K1 format are relative, so reference different cells as the =MyName formula is entered into different cells.