View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Carim Carim is offline
external usenet poster
 
Posts: 510
Default One Cost Divided Among Multiple Date Ranges

Hi,

If I understand correctly, you would be better off :
1. having a count formula which takes care of the exact number of
months
2. dividing your cost total by this number for each month
3. using If function only to determine if the respective month is
available or not

HTH
Cheers
Carim