| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 : Any single button to get sub total and grand total ? | Excel Discussion (Misc queries) | |||
| calculate count on 2006 total, 2005 total, etc... | Excel Worksheet Functions | |||
| Pivots - Auto calc % Sub total is of grand total | Excel Discussion (Misc queries) | |||
| How do i keep the total of 3 variables constant | Excel Discussion (Misc queries) | |||
| Adding Data Using Multiple Worksheets to Total into a Grand Total | Excel Worksheet Functions | |||
Threaded Mode
