View Single Post
  #2   Report Post  
DaveB
 
Posts: n/a
Default

Lars -
Use SUMPRODUCT(...), assume your country names are in A1:A1000, your store
names are in B1:B1000 and the values you want to sum are in C1:C1000:

=SUMPRODUCT(--(A1:A1000="country name"),--(B1:B1000="store
type"),--(C1:C1000))
--
Regards,

Dave


"Lars F" wrote:

Is it possible to sum one column based on two criterias, for example country
and type of store? I have done that for countires with SUMIF, but I now want
to have two parameters instead.
I would appreciate any help on this,
/Lars