SUMIF with multiple conditions

[Gerrit]

Hi there,

I need to generate sums which depend on a number of
criteria.
I have a data input sheet with stocks, stock prices, name
etc. the sums have to be build e.g. under the condition´:
Asset Class (Column X) must be "Stock" but Type (Column Y)
mustn't be "Mutual Fund"...

Currently I have the formula =SUM(If(AssetClass="Stock";if
(Type<>"Mutual Fund")))

Furthermore I have problems when using to names for this
kind of equation.
E.g. for another Sumif - =sum(if(Country=EU;...))) where
EU is a list of countries which build the European Union
and Country is the Column to refer to for the criteria
country..

Thanks a lot

 

[Bob Phillips]

Gerrit,

Basically you want something like

=SUMPRODUCT((X1:X100="Stock)*(Y1:Y100="Mutual Fund),(Z1:Z100)

where Z1:Z100=is the price

If you want names, you have to use workbook names (Insert>Name>Define), and
name X1:X100 to AssetClass say.

Just change the ranges to suit.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Hi there,

I need to generate sums which depend on a number of
criteria.
I have a data input sheet with stocks, stock prices, name
etc. the sums have to be build e.g. under the condition´:
Asset Class (Column X) must be "Stock" but Type (Column Y)
mustn't be "Mutual Fund"...

Currently I have the formula =SUM(If(AssetClass="Stock";if
(Type<>"Mutual Fund")))

Furthermore I have problems when using to names for this
kind of equation.
E.g. for another Sumif - =sum(if(Country=EU;...))) where
EU is a list of countries which build the European Union
and Country is the Column to refer to for the criteria
country..

Thanks a lot