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
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