Counting months with variables

[katja328]

Please see the attached spreadsheet:

I am trying to count the number of months the following way:

D4 should count the cells from C10 to C40 that contain the amount in E4 but not start counting until the number of free months contained in D3 are passed and under no circumstances count more than 12 down


D5 should count the cells starting from C10 to C40 (but not start counting until D3 and D4 have passed) that contain E5 and again under no circumstance count more than 12 months down

Thank you very much!

[DonkeyOte]

Seems to me you want to check out the XL2007 COUNTIFS function in XL Help, eg:

C4: =IF($E4,COUNTIFS($C$10:$C$40,$E4,$B$10:$B$40,">="&$B4,$B$10:$B$40,"<="&$C4),0)