egin{tabular}{|l|r|} hline multicolumn{2}{|l|}{ TOTAL DONATIONS PER ORGANIZATION } \ hline multicolumn{1}{|c|}{ Organization } & Amount \ hline Amnesty International Total & ( $ 0 ) \ hline Animal Shelter Total & ( $ 0 ) \ hline Cancer Society Total & ( $ 0 ) \ hline Diabetic Association Total & ( $ 0 ) \ hline Habitat for Humanity Total & ( $ 0 ) \ hline Homeless Shelters Total & ( $ 0 ) \ hline Leukemia Society Total & ( $ 0 ) \ hline Make a Wish Foundation Total & ( $ 0 ) \ hline Meals on Wheels Total & ( $ 0 ) \ hline Police Federation Total & ( $ 0 ) \ hline Vietnam Veterans Total & \ hline Grand Total & \ hline end{tabular} egin{tabular}{|l|l|} hline multicolumn{1}{|c|}{ AVERAGE DONATION PER ORGANIZATION } \ hline multicolumn{1}{|c|}{ Organization } & Amount \ hline Amnesty International Total & \ hline Animal Shelter Total & \ hline Cancer Society Total & \ hline Diabetic Association Total & \ hline Habitat for Humanity Total & \ hline Homeless Shelters Total & \ hline Leukemia Society Total & \ hline Make a Wish Foundation Total & \ hline Meals on Wheels Total & \ hline Police Federation Total & \ hline Vietnam Veterans Total & \ hline Grand Average & \ hline end{tabular}

\begin{tabular}{|c|c|} \hline \multirow{2}{*}{\multicolumn{2}{|c|}{\begin{tabular}{c} TOTAL DONATIONS PER ORGANIZATION \\ Organization \end{tabular}}} \\ \hline & Amount \\ \hline Amnesty International Total & 50 \\ \hline Animal Shelter Total & 50 \\ \hline Cancer Society Total & 50 \\ \hline \begin{tabular}{|l|} Diabetic Association Total \\ \end{tabular} & 5C \\ \hline Habitat for Humanity Total & 50 \\ \hline Homeless Shelters Total & 50 \\ \hline Leukemia Society Total & 30 \\ \hline Make a Wish Foundetion Total & 50 \\ \hline Meals on Wheols Total & 50 \\ \hline \begin{tabular}{|l|l|l|} Police Federation Total \\ \end{tabular} & 50 \\ \hline \begin{tabular}{|l|l|} Vietnam Veterans Total \\ Cod \end{tabular} & 50 \\ \hline Grand Total & \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline \multicolumn{2}{|l|}{ AVERAGE DONATION PER ORGANIZATION } \\ \hline \multicolumn{1}{|c|}{ Organization } & Amount \\ \hline Amnesty International Total & \\ \hline Asimal Shelter Total & \\ \hline Cancer Society Total & \\ \hline Diabetic Association Total & \\ \hline Habitat for Humanity Total & \\ \hline Homeless Shellers Total & \\ \hline Leukemia Society Total & \\ \hline Make a Wish Foundation Total & \\ \hline Meals on Whools Total & \\ \hline Police Federation Total & \\ \hline Vietnam Veterans Total & \\ \hline Grand Average & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F & G \\ \hline 1 & Submitter & Employee 11 & Last Nam = & First Nar & Organization & 1 Amoul F & Donation Se - \\ \hline 2 & 12/12/2011 & 546 & Daniels & Julie & Amnesty International & $200 & 12/21/2011 \\ \hline 3 & 2/2/2011 & 546 & Daniels & Juhie. & Amnesty International & $200 & 2/21/2011 \\ \hline 4 & 6/6/2011 & 546 & Daniels & Julie & Amnesty International & $200 & 6/21/2011 \\ \hline 5 & 9/9/2011 & 849 & Daniels: & Julie & Amnesty International & $200 & 9/21/2011 \\ \hline 6 & 12/3/2011 & 499 & Cross & Roberta & Animal Shelter & $20 & 12/5/2011 \\ \hline 7 & 12/12/2011 & 657 & Rogers & Scolt & Animal Shelter & $35 & 12/15/2011 \\ \hline 8 & 2/3/2011 & 499 & Cross & Roberta & Animal Shelter & $20 & \begin{tabular}{r} 2/5/2011 \\ \end{tabular} \\ \hline 9 & 2/2/2011 & 657 & Rogers & Scott & Animal Shelter & $35 & 2/15/2011 \\ \hline 10 & 6/3/2011 & 499 & Cross & Roberta & Animal Shelter & 520 & 6/5/2011 \\ \hline 11 & 6/6/2011 & 657 & Rogers & Scott & Animal Shelter & 535 & 6/15/2011 \\ \hline 12 & 9/3/2011 & 499 & Cross & Roberta & Animal Shelter & $20 & 9/8/2011 \\ \hline 13 & 9/9/2011 & 987 & Rogers & Scott & Animal Sholter & $38 & 9/18/2011 \\ \hline 14 & 12/5/2011 & 243 & Bagley & Bob & Cancer Society & 525 & 12/6/2011 \\ \hline 15 & 12/4/2011 & 389 & Fisher & Scott & Cancor Society & 5125 & 12/10/2011 \\ \hline 16 & 122/2011 & 456 & Butler & Amy & Cancer Society & $250 & 12/10/2011 \\ \hline 17 & 12/6/2011 & 832 & Haitz & Todd & Cancer Sociely & 550 & 1/12/14/2011 \\ \hline 18 & 25/2011 & 243 & Bagioy & Bob & Cancer Socioly & $25 & 2/6/2011 \\ \hline 19 & 2/4/2011 & 389 & Fisher & scolt & Cancer Society & 525 & 2/10/2011 \\ \hline 20 & 2/3/2011 & 456 & Butler & Amy & Cancer Society & $250 & 2/10/2011 \\ \hline 21 & 2/6/2011 & 832 & Haitz & Todd & Cancer Society & $50 & 2/14/2011 \\ \hline 22 & 6/512011 & 243 & Bagley & B0b & Cancer Sociely & $25 & 6/6/2011 \\ \hline 23 & 6/4/2011 & 389 & Fisher & Scolt & Cancer Society & 865 & 6/10/2011 \\ \hline 24 & 6/3/2011 & 456 & Butler & Amy & Cancer Society & $250 & 6/10/2011 \\ \hline 25 & 6/6/2011 & 832 & 2 Hoitz. & Todd & Cancer Society & $50 & 6/14/2011 \\ \hline 26 & 9/812011 & 243 & 3 Bagley & Bob & Cancor Society & $28 & 9/9/2011 \\ \hline 27 & 9/4/2011 & 389 & Fisher & Scolt & Cr3 Society & $98 & 9/10/2011 \\ \hline 28 & 9/3/2011 & 489 & Butier & Amy & cinsmociety & $280 & 9/10/2011 \\ \hline 29 & 9/9/2011 & 032 & |Haits & Todd & Cancer Society & 580 & 9/14/2011 \\ \hline 30 & 12/6/2011 & 211 & 1 Smith & James & Diabetic Association & $50 & 12/19/2011 \\ \hline 31 & 12/5/2011 & 654 & Ash & Carlin & Diabotic Association & 5100 & 12/6/2011 \\ \hline 32 & 12/9/2011 & 675 & 5 Ash & Scolt & Diabetic Association & $100 & 12/18/2011 \\ \hline 33 & 12/17/2011 & 987 & 7 Haim & Gary & Drabotic Association & $50 & 12/22/2011 \\ \hline 34 & 2/52011 & 21 & if Smith & James & Diabetic Association & 550 & 2/19/2011 \\ \hline \end{tabular} I need the excel formulas to get to the result, since the data is located on a different sheet and the names of Organization on the answer sheet have the word "total" added to them|