| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I find the month
Help !!! I need to find out how many sales someone did in say Jan. I've got
this so far but it won't work with the date field.. =SUMPRODUCT((D2:D188="*01/2008")*(L2:L1880)) Many thanks in advance.. Opened Sales Person Jan Feb 08-Jan-08 Gary £1,189.11 £2,437.42 19-Dec-07 Anthony £792.81 £2,082.08 19-Dec-07 Anthony £414.06 £409.35 23-Jan-08 Stephen £276.00 £419.38 29-Jan-08 Bobby £298.15 £529.62 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find the MIN of Month and Day only | Excel Discussion (Misc queries) | |||
| I would like to find the last day of a month | Excel Worksheet Functions | |||
| How do i find the first value every month | Excel Discussion (Misc queries) | |||
| Find out first Friday every month | Excel Discussion (Misc queries) | |||
| Find out first Friday every month | Excel Worksheet Functions | |||
Threaded Mode
