Total function, how do can I get totals by type?

[Timothy Reinert]

I have a spreadsheet with a lot of data of which my 5th column (E) is by
country and I want to set up a function where I can get a total by each
country. for instance if I have USA listed 100 times, Canada 50 times,
Germany 40 times and Mexico 20 times I want to have a function that list
these totals for me. Can anyone help me set up this function?

thanks

 

[Bernard Rey]

Timothy Reinert wrote :

I have a spreadsheet with a lot of data of which my 5th column (E) is by
country and I want to set up a function where I can get a total by each
country. for instance if I have USA listed 100 times, Canada 50 times,
Germany 40 times and Mexico 20 times I want to have a function that list
these totals for me. Can anyone help me set up this function?

Select one cell inside the list, then go to "Data" > "Subtotals..." (note:
you'll have to sort your list by country first).

Another solution (if you don't want to sort the list) is to use the "SUMIF"
function. Something like "=SUMIF(E2:E211,"USA",F2:F211)" should sum the
amounts in column F when the column E contains "USA" (I suppose you have 210
rows in which col. E indicates the country, and the amounts are in col. F).

If this doesn't match, just post back giving some more precisions about the
encountered problem.

 

[J.E. McGimpsey]

Timothy Reinert wrote :


Select one cell inside the list, then go to "Data" > "Subtotals..." (note:
you'll have to sort your list by country first).

Another solution (if you don't want to sort the list) is to use the "SUMIF"
function. Something like "=SUMIF(E2:E211,"USA",F2:F211)" should sum the
amounts in column F when the column E contains "USA" (I suppose you have 210
rows in which col. E indicates the country, and the amounts are in col. F).

If this doesn't match, just post back giving some more precisions about the
encountered problem.

A third solution, whether or not you want to sort the data: use a
Pivot Table.