Counting with date criteria

J

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
 
B

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top