| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Which Function to be used??
Hi,
Am Mon, 21 Jan 2013 07:25:09 +0000 schrieb Asrar Ayub: 11/01/2012 11/01/2012 11/07/2012 11/07/2012 11/07/2012 11/07/2012 11/20/2012 11/20/2012 11/20/2012 11/20/2012 I want to know how many counts in November, not by Date. My Output should say as "11" for the above example. you can do it with pivot table. Drag the dates into rows and into values. Group the dates in the rows by month. Or use in D4: =IF(MONTH(C5)=MONTH(C4),"",SUMPRODUCT(--(MONTH($C$4:$C$100)=MONTH(C4)),--($C$4:$C$100<""))) and copy down Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| User Function Question: Collect Condition in Dialog Box - But How toInsert into Function Equation? | Excel Programming | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Excel - User Defined Function Error: This function takes no argume | Excel Programming | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming | |||
Threaded Mode
