Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum with multiple criteria
Hi,
I need to make the sum of the values from a customer in a certain month. month 1 month 2 month 3 customer1 customer2 customer3 customer1 customer2 customer3 Can anyone give the right formula ? I already tried with Sumif and Sum, but nothing worked so far... Thanks, and happy New Year to you all !!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum with multiple criteria
Forgot some important info.
The 'original' data are in colums. Colum A is the Month, Colum B is the customer, colum X is the value. The final result should look like this: month 1 month 2 month 3 customer1 customer2 customer3 Thanks. "Gecko" wrote: Hi, I need to make the sum of the values from a customer in a certain month. month 1 month 2 month 3 customer1 customer2 customer3 Can anyone give the right formula ? I already tried with Sumif and Sum, but nothing worked so far... Thanks, and happy New Year to you all !!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum with multiple criteria
With months in A1:A1000, names in B1:B1000, numbers in X1:X1000
With your table beginning with first name in Z2 and first month in AA1 =SUMPRODUCT(--($A$1000=AA$1),--($B$1:$B$100=$Z2),$X1:$X1000) For more details on SUMPRODUCT Bob Phillips http://www.xldynamic.com/source/xld.SUMPRODUCT.html J.E McGimpsey http://mcgimpsey.com/excel/formulae/doubleneg.html Debra Dalgleish http://www.contextures.com/xlFunctio...tml#SumProduct If column A had dates not months =SUMPRODUCT(--(month($A$1000)=AA$1),--($B$1:$B$100=$Z2),$X1:$X1000) If you are using Excel207, have a look in Help to lean about SUMIFS (with final S) best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Gecko" wrote in message ... Forgot some important info. The 'original' data are in colums. Colum A is the Month, Colum B is the customer, colum X is the value. The final result should look like this: month 1 month 2 month 3 customer1 customer2 customer3 Thanks. "Gecko" wrote: Hi, I need to make the sum of the values from a customer in a certain month. month 1 month 2 month 3 customer1 customer2 customer3 Can anyone give the right formula ? I already tried with Sumif and Sum, but nothing worked so far... Thanks, and happy New Year to you all !!! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum with multiple criteria
Hi,
I assume that the original data is in sheet 1 and the summary you need in sheet 2 sheet 2 column A you have the customer name starting in A2 and in B1 you have the month so in B2 enter =sumproduct((A1=sheet1!$B$1:$B$10000),(B1=sheet1!$ A$1:$A$10000),$X$1:$X$10000 "Gecko" wrote: Forgot some important info. The 'original' data are in colums. Colum A is the Month, Colum B is the customer, colum X is the value. The final result should look like this: month 1 month 2 month 3 customer1 customer2 customer3 Thanks. "Gecko" wrote: Hi, I need to make the sum of the values from a customer in a certain month. month 1 month 2 month 3 customer1 customer2 customer3 Can anyone give the right formula ? I already tried with Sumif and Sum, but nothing worked so far... Thanks, and happy New Year to you all !!! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum with multiple criteria
opps, use this one instead
=SUMPRODUCT(($A2=Sheet1!$B$1:$B$10000),(C$1=Sheet1 !$A$1:$A$10000),$X$1:$X$10000) copy formula to your right and down "Eduardo" wrote: Hi, I assume that the original data is in sheet 1 and the summary you need in sheet 2 sheet 2 column A you have the customer name starting in A2 and in B1 you have the month so in B2 enter =sumproduct((A1=sheet1!$B$1:$B$10000),(B1=sheet1!$ A$1:$A$10000),$X$1:$X$10000 "Gecko" wrote: Forgot some important info. The 'original' data are in colums. Colum A is the Month, Colum B is the customer, colum X is the value. The final result should look like this: month 1 month 2 month 3 customer1 customer2 customer3 Thanks. "Gecko" wrote: Hi, I need to make the sum of the values from a customer in a certain month. month 1 month 2 month 3 customer1 customer2 customer3 Can anyone give the right formula ? I already tried with Sumif and Sum, but nothing worked so far... Thanks, and happy New Year to you all !!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count multiple cells against multiple criteria in an Excel spreads | Excel Worksheet Functions | |||
match multiple criteria ina range from multiple criteria multiplet | Excel Worksheet Functions | |||
Index & Match functions - multiple criteria and multiple results | Excel Worksheet Functions | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions |