Question: In the range C11:C16, use the SUMIFS function to tally the total count of birds for each watcher during the three days. *Please show formula*
In the range C11:C16, use the SUMIFS function to tally the total count of birds for each watcher during the three days.
*Please show formula*


CountsTbl is the name of table shown above
\begin{tabular}{|l|l|r|r|} \hline \multicolumn{1}{|c|}{ A } & \multicolumn{1}{c|}{ B } & \multicolumn{2}{c|}{ C } \\ \hline 1 & Date & Birds Identified & \\ \hline 2 & 11/1/2017 & 26 & \\ \hline 3 & 11/2/2017 & 35 & \\ \hline 4 & 11/3/2017 & 39 & \\ \hline 5 & & & \\ \hline 6 & & & \\ \hline 7 & & & \\ \hline 8 & & & \\ \hline 9 & & & \\ \hline 10 & & & \\ \hline 11 & Brenda & & \\ \hline 12 & Daniel & 15 & Total Birds \\ \hline 13 & Julie & 13 & 28 \\ \hline 14 & Michael & 18 & 23 \\ \hline 15 & Nick & 19 & 18 \\ \hline 16 & Rene & 22 & 38 \\ \hline \end{tabular}Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
