View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Erik (AP Inc.) Erik (AP Inc.) is offline
external usenet poster
 
Posts: 12
Default Total by 2 variables

I want to be able to have a count of entries and be able to total entires per
month depending on what unit they are from.

Example:

Date Unit Savings
1/2/08 P01 100.00
2/3/08 P02 200.00
2/5/08 P01 500.00

Results
P01 Count : P02 Count : P01 Savings : P02 Savings
Jan. 1 0 100.00 0
Feb. 1 1 500.00 200.00

I have the date and the count figured out, but i dont know hoe to decipher
between units.

Thanks for any help