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



I figured out how to do it. Im still working out the kinks, but the basic idea is to use 

