Thread: how do I count the sum of 2 columns in excel? countif(a1:a100='op.
View Single Post
  #1   Report Post  
Bruce
 
Posts: n/a
Default how do I count the sum of 2 columns in excel? countif(a1:a100='op.
I am having trouble with the syntax here nested functions - this is what I am
attempting to do

countif(a1:a100='open' and b1:b100='i')
Reply With QuoteReply With Quote