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
|