| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating number of occurences based on dates
"Henrik Fritsche" wrote in message ... Sorry, it seems not to function. Isnt SUMPRODUCT a times by times calculation ? Hoistorically yes, but see http://www.xldynamic.com/source/xld.SUMPRODUCT.html for a detailed discussion on it's evolvement. Have you got such values functioning in your end by using it ? Had a small type, try these 3 =SUMPRODUCT(--(MONTH(C2:C200)=MONTH(TODAY())-2), --(MONTH(C2:C200)<=MONTH(TODAY()))) =SUMPRODUCT(--(MONTH(C2:C200)=MONTH(TODAY())-2), --(MONTH(C2:C200)<=MONTH(TODAY()))) =SUMPRODUCT(--(MONTH(C2:C200)=MONTH(TODAY())-2), --(MONTH(C2:C200)<=MONTH(TODAY())),B2:B200) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count occurences based on dates | Excel Worksheet Functions | |||
| formula for calculating repeat occurences between specified dates | Excel Discussion (Misc queries) | |||
| Calculating cells based on dates | Excel Worksheet Functions | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
| Calculating Due Dates Based on Payments | Excel Worksheet Functions | |||
Threaded Mode
