| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculation based with Range of Date
Hi
I m facing problem with my worksheets which i have to calculate total sales in particular month. sheet 1 have Date Sale Undr 4% CST Sale Undr 10 CST Sale Undr 4% RST DD/MM/YY 1.10.2005 10000 2.10.2005 250000 3.10.2005 150000 4.10.2005 1000 1.11.2005 2.11.2005 3.12.2005 4.12.2005 1.1.2005 etc Sheet 2 have Quarterly Return Month Sale Undr 4% CST Sale Undr 10 CST Sale Undr 4% RST January February March In Sheet 2 i want to calculate Sale amount for particular month which is in sheet 1 How it can be Thanks and regard |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to check if date falls within range | Excel Worksheet Functions | |||
| HELP - Date Range In 1 Cell Calculation | Excel Worksheet Functions | |||
| overtime formula based on dynamic date range? | Excel Worksheet Functions | |||
| Update cell based on date range | Excel Discussion (Misc queries) | |||
| I have a list of dates that I need to count based on a date range | Excel Worksheet Functions | |||
Threaded Mode
