View Single Post
  #1   Report Post  
spottkitty
 
Posts: n/a
Default Count if for every other row

I have this formula that adds every other column in my sheet.

=SUM(AH16,AJ16,AL16,AN16,AP16,AR16,AT16,AV16,AV17, AX16,AZ16)

I'm trying to countif the columns next to these that are 1 or greater. the
ways I've tried the formula return errors.

Any insight would be appreciated!

Thanks!