Thread
:
Total by 2 variables
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
Total by 2 variables
Show us YOUR efforts
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Erik (AP Inc.)" wrote in message
...
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett