| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sub total data by year
I have a sheet with about 3000 rows for claim data. Column B shows Date,
Column C shows amount. The date range spans many years. I want to sub-total amount per callendar year. I tried SUMIF but could not make it work. Any ideas? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sub total data by year
Just need to specify a year_num in the following formula:
=SUMPRODUCT(--(YEAR(B1:B3000)=year_num),C1:C3000) -- Regards, Dave "Trond" wrote: I have a sheet with about 3000 rows for claim data. Column B shows Date, Column C shows amount. The date range spans many years. I want to sub-total amount per callendar year. I tried SUMIF but could not make it work. Any ideas? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sub total data by year
Amazing! How simple when you know what to do. Thank you very much.
Regards, Trond "David Billigmeier" wrote: Just need to specify a year_num in the following formula: =SUMPRODUCT(--(YEAR(B1:B3000)=year_num),C1:C3000) -- Regards, Dave "Trond" wrote: I have a sheet with about 3000 rows for claim data. Column B shows Date, Column C shows amount. The date range spans many years. I want to sub-total amount per callendar year. I tried SUMIF but could not make it work. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup to Return a Range of Data | Excel Discussion (Misc queries) | |||
| Macro question | Excel Worksheet Functions | |||
| Pivot table question: How to display total and percent for data simultaneouly | Excel Discussion (Misc queries) | |||
| Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Linear Mode
