IF Statement

  • Thread starter Thread starter jerious
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

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

Excel VBA - counting cells by colors and names to it in two different rows. 0
Multiple if statements in one cell 8
Windwithme COMPUTEX 2024 Connecting AI new products shared with ShowGirls 4
Need formula to count blank cells 5
Excel Urgent help in Excel / Access Report 0
Show an Employee with no reviews 6
What to Choose - ForteAgent or Newshosting 3
Comparing data on 2 worksheets 1

Back
Top