Hi there every one. I have built a mini CRM type spreadsheet to track very specific client appointment centered information. I also built a couple of summary pages that I want to have calculate some reporting numbers for me based on the information.

In this specific formula, I am wanting to calculate the sum of several columns, each one individually relating to a date range in a coordinating column (so the total of 7 columns is based on the 7 coordinating columns holding date range). Below is the expression I developed to give me the accurate count. However, this formula is so long, I am wondering if anyone knows a shorter, or simpler way to express this formula.

Also, just to clarify, I am totaling this equation on a separate worksheet than where the data is held. The 'CLIENT!' is the worksheet where the data is held.

=SUMIFS(CLIENT!S2:S59,CLIENT!U2:U59,"<=3/31/2016",CLIENT!U2:U59,">=1/1/2016")+SUMIFS(CLIENT!W2:W59,CLIENT!Y2:Y59,"<=3/31/2016",CLIENT!Y2:Y59,">=1/1/2016")+SUMIFS(CLIENT!AA2:AA59,CLIENT!AC2:AC59,"<=3/31/2016",CLIENT!AC2:AC59,">=1/1/2016")+SUMIFS(CLIENT!AD2:AD59,CLIENT!AF2:AF59,"<=3/31/2016",CLIENT!AF2:AF59,">=1/1/2016")+SUMIFS(CLIENT!AG2:AG59,CLIENT!AI2:AI59,"<=3/31/2016",CLIENT!AI2:AI59,">=1/1/2016")+SUMIFS(CLIENT!AJ2:AJ59,CLIENT!AL2:AL59,"<=3/31/2016",CLIENT!AL2:AL59,">=1/1/2016")+SUMIFS(CLIENT!AM2:AM59,CLIENT!AN2:AN59,"<=3/31/2016",CLIENT!AN2:AN59,">=1/1/2016")

In case it helps to clarify further, this formula is giving me the total number of hours spent with clients in a quarter. The reason there are multiple hour columns, is that we track by 1st appointment, 2nd appointment, etc.