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 !!!