how to in excel for macbook: Click the Static sheet tab. Consolidate the data without links from the four state worksheets using SUM. Make necessary changes in the Consolidate dialog box.

Home Insert Aa Colors Draw Page Layout Formulas Data Review \begin{tabular}{cc|cc|c|} \hline A1 & v^ & & fx & American River Cycling Club \\ \hline & A & B & c & D \\ \hline & & American River Cycling Club \\ \hline \end{tabular} Race Participation Totals \begin{tabular}{|c|c|c|c|} \hline Date & \# of Riders & Male & Female \\ \hline \end{tabular} April 1 April 4 April 14 April 23 May 1 May 8 May 21 June 1 June 5 16 \begin{tabular}{l|l|l|l|l|l} \hline & Illinois & Massachusetts & Texas & Washington & Static \\ \hline Ready & IV Accessibility: Good to go & & \end{tabular} Home Insert Aa Colors Draw Page Layout Formulas Data Review \begin{tabular}{cc|cc|c|} \hline A1 & v^ & & fx & American River Cycling Club \\ \hline & A & B & c & D \\ \hline & & American River Cycling Club \\ \hline \end{tabular} Race Participation Totals \begin{tabular}{|c|c|c|c|} \hline Date & \# of Riders & Male & Female \\ \hline \end{tabular} April 1 April 4 April 14 April 23 May 1 May 8 May 21 June 1 June 5 16 \begin{tabular}{l|l|l|l|l|l} \hline & Illinois & Massachusetts & Texas & Washington & Static \\ \hline Ready & IV Accessibility: Good to go & & \end{tabular}