Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a sheet with a couple hundred rows. Each row has an 'owner' and a pass/fail field. I am making a second sheet that has statistics for the users. So for each user it will count the number of passes, fails and non-completes. My question is how do I write a function to do this? My guess is its something like countif(sheet1!a1:aN, AND(a[i][owner]=name, a[i][pass/fail]=pass). Obviously though this syntax doesnt work in excel, so I would like to figure out how to do it

share|improve this question
i suppose a simple pivot would do – Firee Mar 4 '14 at 17:48
Its already a pivot table. The pivot table works fine, but you have to manually set up the filters and then check the values. It would be nice if I could have a separate area with all the values good to go. – David Grinberg Mar 4 '14 at 17:57
up vote 1 down vote accepted

I figured out how to do it. Im still working out the kinks, but the basic idea is to use COUNTIFS. The general format is something like COUNTIFS(NameRange,name,Pass/failRange,"pass").

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.