View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gecko Gecko is offline
external usenet poster
 
Posts: 18
Default 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 !!!