Counting with date criteria

[jambre]

Here's my layout:

Column A= Customer ID
Column B= Service #1(If the customer subscribes to the service, ente
"X")
Column C=Service #2 (" " " " " "
" ")
Note: A row cannot have X's in both B and C-ie each row represents on
instance of "service"
Column D-Service Start Date
Column E-Service Termination Date
Column F onwards-fees invoiced each month (AUG-06, SEP-06,...)for eac
service provided
At the bottom of Column F,G, H.... I need to total the number of eac
service provided for that month-COUNTIF doesn't seem to recgniz
dates-how can I do this?

Thanks,
Ji

 

[Bob Phillips]

Maybe

=SUMPRODUCT(--(MONTH($D$2:$D$200)<=8),--(MONTH($E$2:$E$200)>=8),--(B2:B200="
X"))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Bob Phillips]

Maybe

=SUMPRODUCT(--(MONTH($D$2:$D$200)<=8),--(MONTH($E$2:$E$200)>=8),--(B2:B200="
X"))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)