Hi
Firstly
Copy your table from A1

Go to cell# D2 and paste this formula and press Ctrl+Shift+Enter

=SUM(IF($B$2:$B$4=$B2,IF($A$2:$A$4=$A2,$C$2:$C$4,0 ),0))

This is an conditional formula which you can find by yourself at
Menu/tools/conditional sum.

you can also type in Lab in cell A6 and date 5/2 in b6 cell... then copy the
formula below in cell C6.

=SUM(IF($B$2:$B$4=$B6,IF($A$2:$A$4=$A6,$C$2:$C$4,0 ),0))
Do the same thing... it's and array formula so you have to use
ctrl+shift+enter to get the result...

Now if you want to creat the graph... it's way easier using the pivot graphs
or even to classify the data use the pivot tables... it's way easier than
giving the conditional sum...

Guess it will help

Ciao

Anant

"Scrappy" wrote:

I have a spreadsheet that uses visual basics to place info in to different
worksheets. What formula do I use to sort by 2 different columns and then
add a third? I need to sperate the data more to create different graphs.
Example
Dogs Date # pups
Lab 5/2 3
Lab 5/2 2
Beagle 5/2 5

Find Total "# pups" from "labs" on "5/2"

Hope someone understands what I am looking for. Thanks