Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
To Refer particular Month in large datas
I having large date in one Column with different dates in data
Format(mm/dd/yyyy). I want to refer how many datas in particular month |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
To Refer particular Month in large datas
As long as its real dates, whatever date-format subsequently applied doesn't
matter This will count all dates in col A which are in Feb 2008: =SUMPRODUCT(--(TEXT(A2:A1000,"mmm yyyy")="Feb 2008")) And this will sum col B for all dates in col A which are in Feb 2008: =SUMPRODUCT(--(TEXT(A2:A1000,"mmm yyyy")="Feb 2008"),B2:B1000) Adapt to suit .. -- Max Singapore http://savefile.com/projects/236895 Downloads:23,000 Files:370 Subscribers:66 xdemechanik --- "PERANISH" wrote: I having large date in one Column with different dates in data Format(mm/dd/yyyy). I want to refer how many datas in particular month |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
To Refer particular Month in large datas
If you really don't care about year, as your post says nothing about that, then
=SUMPRODUCT(--(MONTH(A1:A20)=1)) Would count the number of January dates in the range, if you do care about year then you could use =SUMPRODUCT(--(A1:A20=C1),--(A1:A20<=C2)) Where you enter the first day of the month in question in C1 as a date, and the ending date of that month in C2. -- If this helps, please click the Yes button Cheers, Shane Devenshire "PERANISH" wrote: I having large date in one Column with different dates in data Format(mm/dd/yyyy). I want to refer how many datas in particular month |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting datas in one range based on datas in another range | Excel Discussion (Misc queries) | |||
A chart with 2 datas | Charts and Charting in Excel | |||
import datas from one excel to another | New Users to Excel | |||
Sorting a large list by date (month number) | Excel Discussion (Misc queries) | |||
Datas from Access | Excel Discussion (Misc queries) |