Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Sumif with 2 cell criteria
A B C D E F
1/06 2/06 3/06 4/06 1 ford 2 chey 3 dodge OK, on another sheet I have 20,900 lines of items I have sold to these customers. I have the cust name in column A, the date as listed in row 2 is in column E, and the number of pcs sold is in column C. I want to get the total amount sold to each cust during each month. Any help would be great. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Sumif with 2 cell criteria
Cube Farmer:
The easiest way to do it is to use a pivot table. I'm not sure on the date format, is it month/year or day month? Is the date a hard coded 1 / 0 6 or is it just formated to show the date that way? You can use the sum if but the pivot will do it all for you and you don't need to worry about missing names. -- HTHs Martin "Cube Farmer" wrote: A B C D E F 1/06 2/06 3/06 4/06 1 ford 2 chey 3 dodge OK, on another sheet I have 20,900 lines of items I have sold to these customers. I have the cust name in column A, the date as listed in row 2 is in column E, and the number of pcs sold is in column C. I want to get the total amount sold to each cust during each month. Any help would be great. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Place X in cell if criteria met` | Excel Discussion (Misc queries) | |||
I am trying to color fill a cell based on specific criteria | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
SUMIF, wildcard and cell ref | Excel Worksheet Functions | |||
"criteria" in a sumif refering to the value in another cell | Excel Discussion (Misc queries) |