Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a spread sheet that looks like this
CO. Month Amt Apple 11 $5000 Apple 12 3000 Orange 11 500 Orange 11 300 Apple 11 50 Peach 11 6000 Apple 11 150 In a differnet spreadsheet, I want to look up each company based on the month it is found in and sum the amounts given. Example November Spreadsheet Co. Total Apple 5200 Orange 800 Peach 6000 December Spreadsheet Co. Total Apple 3000 Orange - Peach - This will continue throughout the 12 months. the first spreadsheet is the main one where information will be inputed. I need the formula to not only look at the month but who the company is as well. I used to SUMIF function when i was looking at just the month in general but now I need to add to the formula so it will only add those rows that have the correct company attached. Help will be much appreciated. Thanks, Sally |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sum based on criteria in rows and columns | Excel Discussion (Misc queries) | |||
How to swap rows and columns? | Excel Discussion (Misc queries) | |||
autofill information from rows to columns without using transpose | Excel Discussion (Misc queries) | |||
Clearing information in certain columns | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) |