View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Erinayn Erinayn is offline
external usenet poster
 
Posts: 23
Default Formula Help please

I just need a formula that I'm sure you can all help with. I have a data set
that is as follows:

Invoice #, Code, Description, Amt, Date Paid (Q1, Q2, etc.)

I need to update our schedule with the sum per code per quarter e.g.:

Code Date Sum
A.1 Q1 $43
A.1 Q2 $35
A.1 Q3 $38
A.1 Q4 $38
T.3 Q1 $12
T.3 Q2 $57 and so on.

Thanks in advance.