RE: Help with SUMIF

Giganews Newsgroups
Subject: RE: Help with SUMIF
Posted by:  Jim May
Date: Wed, 17 May 2006

in Cell A6 enter Cat - White
in B6 enter  =sumif($A$2:$A$4,"Cat",B2:B4)

"sumitk" wrote:

> Hi. I need to be able to do a summary report where I need to add all the
> numbers if the row and column headers both meet certain criteria. For
> example, in the table below, I would like to get  a value for the combination
> Cat/White (i.e. 5+35 = 40) or Dog/Brown (i.e. 30)
> Row/Col.    A          B      C    D
> 1    Animal/Color  White      Black    Brown
> 2    Cat          5      10    15
> 3    Dog          20      25    30
> 4    Cat          35      40    45
> In this particular situation, I do not want to use a pivot table. I did
> something like this a while ago using a formula but cant seem to recall it
> anymore. Any suggestions would be greatly appreciated. Thanks in advance.


In response to

Help with SUMIF posted by sumitk on Wed, 17 May 2006