title: Google sheets formula to add order quantities over several sheets
body: <p>here is a link to my google sheet for reference: [https://docs.google.com/spreadsheets/d/1tUlqB2tsH4xEsxYiMv1CiUIY3hhLGpM-1G8eWOyZPWk/edit?usp=sharing]</p>
  <p>What I am trying to do is in the &quot;Clients&quot; sheet there is the column &quot;Orders&quot;. Here I want a count of all the times that &quot;Client ID&quot; has been used across all the other pages. Any tips on what formula to use? Thanks</p>