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