Help with SUMIF

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

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.

Replies