What does this formula mean?

B

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,
 
M

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.
 
S

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using <= in countifs statement 1
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Copy addition formula of non-consecutive horizontal cells 2
Finding the weighted average of text that have been given values 1
counts repeated number in two different area only once 2
Embed the same Excel multiple times 0
What does this formula mean [$-F400]h:mm:ssAM/PM 2
What does this formulea mean? 14

Top