| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Greater than a month
I have these two formulas below working great. I have been asked to modify
it by doing the calculation for a period greater than one month. I currently identify the month by, "TEXT(G17,"mmyyyy")". How do I modify this to calculate if the data is between two dates. Thanks. =COUNT(IF(TEXT(Work!$N$3:$N$5724,"mmyyyy")=TEXT(G1 7,"mmyyyy"),IF(Work!$O$3:$O$5724="",Work!$O$3:$O$5 724))) =AVERAGE(IF(TEXT(Work!$N$3:$N$5724,"mmyyyy")=TEXT( G17,"mmyyyy"),IF(Work!$O$3:$O$5724<"",Work!$B$3:$ B$5724))) |
| 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 | |||
| When using MONTH function on Blank Cell!! Returns Month=Jan! | Excel Discussion (Misc queries) | |||
| transfer cell $ amount to other sheet month-to-month without overc | Excel Discussion (Misc queries) | |||
Threaded Mode
