- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2006 June
- Using multiple criterie in one column to sum another column

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?

- RE: Using multiple criterie in one column to sum another column posted by excelent on Thu, 22 Jun 2006