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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()