View Single Post
  #4   Report Post  
William Horton
 
Posts: n/a
Default

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