Step $4$

Sort the data by country and add a new column $($column $H)$ to add up the volume of falling water from the greatest rivers in each country listed. Use the values in the Volume $(cu\frac{m}{sec})$ column and not the values in the Volume $($cu ft $/$ sec$)$ column.

First do this manually in column $H,$ selecting the ranges yourself, if time permits $($after you have finished part $3),$ come back and try and do it dynamically $($without hardcoded rages$)$ in column I. Your dynamic formula should work when pasted$/$dragged into the other rows without changes.

Hint $1$: You will need to use an if statement, e$.$g$.=$if$($country $=$ prev country, this, that$)$

Hint $2$: You can either use the SUMIF function described in class, or you can break this question into two steps, first use a helper column to calculate the totals for each country and then modify this column so that each country total is only shown once in the column.

The result should look like the following screenshot $($only columns $G,H$ and I are shown$),$ you may also have a helper column $($not used$/$shown here$)$:

$\backslash$table$[[$G$,$H$,1],[$Country$,$Total Volume for Country $($manual sum range$),$Total Volume for Country $($using one formula$)],[$Angola$,566,566],[$Argentina$,1746,1746],[$Brazil$,2832,2832],[$Canada$,12171,12171],[$Canada$],[$Canada$],[$Canada$],[$Canada$],[$Canada$],[$Canada$],[$Canada$],[$Canada$],[$Canada$],[$Canada$],[$Canada$],[$Canada$],[$Canada$],[$Canada$],[$Canada$],[$China$,425,425],[$Democratic Republic of the Congo,$67818,67818],[$Democratic Republic of the Congo$],[$Democratic Republic of the Congo$],[$Gabon$,900,900],[$Guyana$,663,663],[$Iceland$,1436,1436]]$