Using multiple criterie in one column to sum another column

Giganews Newsgroups
Subject: Using multiple criterie in one column to sum another column
Posted by:  Asa_johannesen
Date: Thu, 22 Jun 2006

I would like to add data in column A by criteria from column B. Both columns
contain numbers and I want two criteria from column B (I think). I Basically
what I want is to say that if the numbers in column B are between 4 and 10
(including 10 and not 4) I want the sum of the corresponding numbers in
column A. Is this making sense? So if column A had 2,2,2,4,6,3,1,7,3,2 and
column B had 12,4,2,6,10,3,5,17,9,4 I would want the result to be 14. I have
tried many variations of sum.if and sumproduct and so on and nothing seems to
work. I either get an error message saying that there is a flaw in the
formula (it doesn't like the "," I use to separate things with and so on) or
I get a return of "0". Can anyone tell me what I am supposed to do?

Replies