|Subject:||Re: sumif for multiple criteria|
|Posted by:||Dave Peterson (peters…@verizonXSPAM.net)|
|Date:||Wed, 17 May 2006|
Adjust the ranges to match--but you can't use whole columns.
=sumproduct() likes to work with numbers. The -- stuff changes trues and falses
to 1's and 0's.
Bob Phillips explains =sumproduct() in much more detail here:
And J.E. McGimpsey has some notes at:
If you have lots of these to do, you may want to invest a little time in
learning about pivottables.
Here are a few links:
Debra Dalgleish's pictures at Jon Peltier's site:
And Debra's own site:
John Walkenbach also has some at:
(look for Tony Gwynn's Hit Database)
Chip Pearson keeps Harald Staff's notes at:
MS has some at (xl2000 and xl2002):
> 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