close
I am trying to create a formula to give me a count of all of the rows that
have a false value in column 1 and a true value in the same row of column 2.
I thought that the CountIf formula would work but it doesn't seem to do
comparisons -- Here's what I was thinking
=CountIf((a1:a10,quot;falsequot;) and (b2:b10,quot;truequot;))
but that doesn't work -- does anyone have any suggestions?
Thanks,
Gail
全站熱搜