Thread: Formulas
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gail
 
Posts: n/a
Default Formulas

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,"false") and (b2:b10,"true"))

but that doesn't work -- does anyone have any suggestions?

Thanks,

Gail