You can alway use the conditional sum wizard too. It is found via the Excel
menu path Tools / Wizard / Conditional Sum. It is an Excel add-in so you may
have to add it first. However, the SumProduct formula suggested by Dave and
Bob is more efficient. The Wizard is user/newbie friendly.
"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
|