michelle.lewis-miller’s Profile

Community member since May 2018

points
10

1

Hi all - I cannot figure out what's going wrong here.

 

I'm trying to count rows in another sheet ("Sheet A") where both the following are true:

  • Done = 0
  • IsChild = 0

My formula is: 

  • =COUNTIFS({Sheet A Range 2}, 0, {Sheet A Range 4}, 0)

 

Now this works perfectly!

 

So in a cell right below that