View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
markincyberspace markincyberspace is offline
external usenet poster
 
Posts: 1
Default partial sum of a column, according to another column value...

Hi,

I've created a pivot table containing rows showing transactions spread
across a number of columns. Two of the columns are 'week #' and
'transaction'. Multiple transactions appear for each week #.

How can I sum the total number of tranactions for each of the week?

Many thanks in advance.