|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.
MCSD.NET, Microsoft Office XP Master
> 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.
sumif for multiple criteria posted by Inter on Wed, 17 May 2006