| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find Sum of Values corresponding to each value type
I have two colums - 1) Expenditure Type, 2) Expenditure Amount. with many
rows. At the bottom of the spreadsheet, I'd like to display the total expenditure amount corresponding to each Expenditure Type: Eg: Expenditure Type|Expenditure Amount Stationery|200 Stationery|200 Gifts|200 Essentials|100 Stationery|300 At the end of the spreadsheet: Stationery|Gifts|Essentials 700|200|100 Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find Sum of Values corresponding to each value type
With data arranged in this order; Try SUMIF() formula as below
Col A Col B Col C Col D Exp Type Exp Amnt Exp Type Total Stationery 200 Stationery =SUMIF(A:A,C2,B:B) Stationery 200 Gifts 200 Gifts 200 Essentials 100 Essentials 100 Stationery 300 If this post helps click Yes --------------- Jacob Skaria "Evans" wrote: I have two colums - 1) Expenditure Type, 2) Expenditure Amount. with many rows. At the bottom of the spreadsheet, I'd like to display the total expenditure amount corresponding to each Expenditure Type: Eg: Expenditure Type|Expenditure Amount Stationery|200 Stationery|200 Gifts|200 Essentials|100 Stationery|300 At the end of the spreadsheet: Stationery|Gifts|Essentials 700|200|100 Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match function won't recognize values unless I type them | Excel Worksheet Functions | |||
| find location of maximum and get the category type | Excel Discussion (Misc queries) | |||
| FIND type mismatch error, but don't see it | Excel Worksheet Functions | |||
| changing the default type of searching in the find function | Excel Discussion (Misc queries) | |||
| VLOOKUP: type or paste values | Excel Worksheet Functions | |||
Linear Mode
