| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search multiple cells with conditions, sum and auto populate!
I am hoping that this will be an easy question to answer. Please note that I
am familiar with Excel but I do not have much experience with involved formulas. I want to create a formula that allows me to search my spreadsheet for specific entries that were made in a certain month and sum the totals and auto populates a separate report. Relatively straight forward! Scenario: Search for all entries in €śJul 2007€ť called €śPaper€ť and total the sales and drop the sum into the Annual Report. Data Table Date Item Sales 05 Jul 2007 Paper 20.00 07 Jul 2007 Ink 10.00 20 Jul 2007 Pallets 40.00 21 Jul 2007 Paper 20.00 25 Jul 2007 Ink 10.00 29 Jul 2007 Pallets 40.00 Annual Report Item Jul Aug Sep Total Paper 40.00 40.00 Ink 20.00 20.00 Pallets 80.00 80.00 Total 140.00 140.00 I hope some can help me with this. Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can I auto-populate cells on another sheet? | Setting up and Configuration of Excel | |||
| can I auto-populate cells on another sheet? | Excel Discussion (Misc queries) | |||
| Auto Populate Cells | Setting up and Configuration of Excel | |||
| Auto populate cells | Excel Discussion (Misc queries) | |||
| Auto populate cells based on 2 cells division. | Excel Discussion (Misc queries) | |||
Threaded Mode
