IF Statement
 

I am working with a document that shows pay rate % change for each year for
each employee. If they show any number (positive or negative), it means they
have had their yearly review. How can I create a total row that shows how
many people this past year still need their reviews? I was thinking of using
an if statement but I am unsure of how to set it up.Thanks

IF Statement
 

Give this array-entered** formula a try...

=COUNT(IF(A1:A1000<0,1))

**Commit this formula with Ctrl+Shift+Enter, not just Enter by itself.

Change the range to suit your conditions.

--
Rick (MVP - Excel)


"jerious" wrote in message
...
I am working with a document that shows pay rate % change for each year for
each employee. If they show any number (positive or negative), it means
they
have had their yearly review. How can I create a total row that shows how
many people this past year still need their reviews? I was thinking of
using
an if statement but I am unsure of how to set it up.Thanks