What does this formula mean?

[bmac]

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,

 

[macropod]

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.

 

[Sheeloo]

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.