Filord is a powerful Excel utility designed to save you time and effort on routine tasks - find unique and duplicate values, reverse order of rows, get subtotals and more. Free installation, seven built in functions, no learning and skills required – get your issue solved in 15 minutes from now on.
Download (1.5 Mb)
Totals
This function returns totals for one column with sums of values for another column. It's also possible to search for min and max value.
Additional column "Records" will display the number of entries found.
Example:
Show subtotals for "Expenses" column with sums for "Price" column.
Output table: (the initial table is not shown)
| Expenses | Price, Total | Records | |
| 1 | Furniture | 1520 | 4 |
| 2 | Hardware | 310 | 28 |
| 3 | Rent | 12000 | 12 |
learn more
We want you to find this page by the following keywords:
excel totals, display totals, excel subtotals, group total in excel, using subtotals, totals from excel, totals by column, excel formula total, excel list total, xls total, sub total in excel
how it works:
load file(s)
open Function Wizard
choose Totals function
specify file number
select one column for totals
select 'sum', 'min' or 'max'
specify the second column
press Run button to get the results
load file(s)
open Function Wizard
choose Totals function
specify file number
select one column for totals
select 'sum', 'min' or 'max'
specify the second column
press Run button to get the results
