IF Statement

J

jerious

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
 
R

Rick Rothstein

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