title: Worked days count
body: <p>I have a monthly report on google sheets(excel format) that I am trying to to fix. So I have 17 workers. The formula that Iam trying to make is, it should count how many days workers worked in a month. Workers day-offs are not obvious(we decided everyday) it shows in the graph, name, job location or day-off <a href="https://i.stack.imgur.com/NGSAO.jpg" rel="nofollow noreferrer">Screenshot</a>
  it is in P column and i tried to write this formula:</p>
  
  <pre><code>=If(And("P2,P21,P43,P65,P86,P103,P123,P144,P165,P186,P207,P228,P249,P270,P291,P312,P333,P354,P375,P396,P417,P438,P459,P481,P502,P523,P545,P566,P588,P609,P630","x=1","x=off=0"))
  </code></pre>
  
  <p>I know this is not correct, does anyone know how to put it together? this formula is only for one worker, for others I will copy paste</p>