Counting with date criteria
 

Here's my layout:

Column A= Customer ID
Column B= Service #1(If the customer subscribes to the service, enter
"X")
Column C=Service #2 (" " " " " " "
" ")
Note: A row cannot have X's in both B and C-ie each row represents one
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 each
service provided
At the bottom of Column F,G, H.... I need to total the number of each
service provided for that month-COUNTIF doesn't seem to recgnize
dates-how can I do this?

Thanks,
Jim


--
jambre
------------------------------------------------------------------------
jambre's Profile: http://www.excelforum.com/member.php...o&userid=22296
View this thread: http://www.excelforum.com/showthread...hreadid=573629

Counting with date criteria
 

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)

"jambre" wrote in
message ...

Here's my layout:

Column A= Customer ID
Column B= Service #1(If the customer subscribes to the service, enter
"X")
Column C=Service #2 (" " " " " " "
" ")
Note: A row cannot have X's in both B and C-ie each row represents one
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 each
service provided
At the bottom of Column F,G, H.... I need to total the number of each
service provided for that month-COUNTIF doesn't seem to recgnize
dates-how can I do this?

Thanks,
Jim


--
jambre
------------------------------------------------------------------------
jambre's Profile:
http://www.excelforum.com/member.php...o&userid=22296
View this thread: http://www.excelforum.com/showthread...hreadid=573629