| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Differentiating data by year into columns
Would SUMPRODUCT work for you? Try, =SUMPRODUCT((YEAR(Sheet2!A2:A6)=YEAR(A1))*(Sheet2! B2:B6="USA")*(Sheet2!C2:C6)) Sheet2! is your data dump. A:A is Date, B:B is Country and C:C are the values to sum. A1 is where your NOW()-730 is located. You can refer to a cell that contains the country name rather than typing in the country. Just an FYI, if your data dump has headers like "Date" in the first row, your SUMPRODUCT range should start on the second row. That is because the YEAR function of text like Date will return a VALUE error. Does that help? Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=515421 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I lookup data based on two columns of data | Excel Worksheet Functions | |||
| how to split data into columns and arrange the resulting data | Excel Discussion (Misc queries) | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Text to Columns / Importing Data | Excel Discussion (Misc queries) | |||
| How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
