What does this formula mean?
 

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,

What does this formula mean?
 

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,

What does this formula mean?
 

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,