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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculation based with Range of Date
B2: =SUMPRODUCT(--(TEXT(Sheet1!$A$2:$A$200,"mmmm")=$A2),Sheet!B$2:B$ 200)
copy down and across -- HTH Bob Phillips (remove nothere from the email address if mailing direct) "Rao Ratan Singh" wrote in message ... 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 |
Reply |
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 |