| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Month value
In my previous formula I left out the MONTH function around the (--(1&E1&0)
portion. Please correct -- Thanks, Shane Devenshire "DaveKid" wrote: =IF(VariousCell="Week",COUNTIF(Combined!U:U,CONCAT ENATE(A6,"Yes")),IF(VariousCell="Month",COUNTIF(Co mbined!X:X,CONCATENATE(A6,"Yes")) This cell is linked to Various cell which is a drop down containing month, week, year. If you select Week it counts data in a concatenated column which is up until that week you have selected. This is possible as the weeks contain numbers i.e. Week 01, Week 02 and excel is able to read the number prior to the week you have selected. This is not possible with the month as it is displayed as text November, December etc and excel cannot give this a value. Does any oine know how to overcome this problem?????? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel to make the days cary over month to month automaticly | New Users to Excel | |||
| Excel 2003 month to month data change grid | Excel Discussion (Misc queries) | |||
| Subtract a future month from the current month to get remaining m. | Excel Worksheet Functions | |||
| Create Month Timetable on a worksheet different month each works | Excel Worksheet Functions | |||
| transfer cell $ amount to other sheet month-to-month without overc | Excel Discussion (Misc queries) | |||
Threaded Mode
