Help please, what does the following formula mean?

=COUNTIF('anotherworksheet'!B:B,"'Area'")

I understand the countif function and the reference to another worksheet. I
am not sure how the "!B:B,"'Area'")" reference works. The result of the
formula appears to be count of the number of rows with values in a column
named "Area" in cell B1. I am just not sure now the and the "Area" are used.

Thanks in advance,

Hi bmac,

Basically, the formula says count the values in column B that are greater than the value named 'Area'. 'Area' could refer to a cell
or could be a constant - check via Insert|Name.

--
Cheers
macropod
[MVP - Microsoft Word]


"bmac" wrote in message ...
Help please, what does the following formula mean?

=COUNTIF('anotherworksheet'!B:B,"'Area'")

I understand the countif function and the reference to another worksheet. I
am not sure how the "!B:B,"'Area'")" reference works. The result of the
formula appears to be count of the number of rows with values in a column
named "Area" in cell B1. I am just not sure now the and the "Area" are used.

Thanks in advance,

Does this work?

If Area is the name which refers to any cell then
=COUNTIF(B:B,""&Area) will sum the values in the cells in col B where it is
more than Area. If Area points to 10 then it will sum all cells with value
greater than 10.

"bmac" wrote:

Help please, what does the following formula mean?

=COUNTIF('anotherworksheet'!B:B,"'Area'")

I understand the countif function and the reference to another worksheet. I
am not sure how the "!B:B,"'Area'")" reference works. The result of the
formula appears to be count of the number of rows with values in a column
named "Area" in cell B1. I am just not sure now the and the "Area" are used.

Thanks in advance,