RE: sumif for multiple criteria

Giganews Newsgroups
Subject: RE: sumif for multiple criteria
Posted by:  Chris Marlow
Date: Wed, 17 May 2006


SUMPRODUCT may help.

Assuming you paste your data in top left corner of the sheet;


But commit with CTRL-SHIFT-ENTER to make it an array formula.



Chris Marlow
MCSD.NET, Microsoft Office XP Master

"Inter" wrote:

> I'm trying to sum the contents of multiple rows based on specifying 2
> criteria, e.g.
> downloads  brand  country
>    5                A          US
>    10              A          US
>    10              B          UK
>    5                B          UK
>    10              A          UK
>    10              B          US
> And i want to add the downloads for brand B in the UK...
> A bit of help would be much appreciated.
> Thanks



In response to

sumif for multiple criteria posted by Inter on Wed, 17 May 2006