| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula
I have a row of dates i.e., 03-Mar-07, 04-Apr-08, 02-Feb-07, 11-Nov-08...and
I want to COUNTIF all dates in '08' (for instance)...regardles of day and month...how do I write the formula...thank you |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Formula
something like =Sumproduct(--(Year(A1:Z1)=2008) adjust range as necessary. -- NBVC Where there is a will there are many ways. 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=125036 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Formula
=SUMPRODUCT(--(YEAR(1:1)=2008))
-- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "JG" wrote: I have a row of dates i.e., 03-Mar-07, 04-Apr-08, 02-Feb-07, 11-Nov-08...and I want to COUNTIF all dates in '08' (for instance)...regardles of day and month...how do I write the formula...thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
| Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
| Excel Formula Doesn't Execute (Shows formula-not the calcuation) | Excel Discussion (Misc queries) | |||
| Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
| How do I view formula results intead of formula in excel? | Excel Worksheet Functions | |||
Linear Mode
