View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] lovepeaceofmind@yahoo.com is offline
external usenet poster
 
Posts: 29
Default sum for each month

hi, everyone:

I have two columns, column A and Column B. Column A is the date in
format of mm/dd/yyyy. Column B is the cost corresponding to each date.
How to get the sum of cost for each month in pivot table? I would also
like to know the count of dates for each month.

I appreciate your help!

Jorge