# Thread: Sum with Criteria (2K3)

1. ## Sum with Criteria (2K3)

I have a spreadsheet in which I would like to sum numbers in a range of cells based on criteria in a cell outside of that range. I have attached a copy of the spreadsheet for reference.

Example: In the cell AH10 labeled with "S", I would like a total of all numbers in the range c10:ag10 IF the cell under that number has either an "S" or "A".

Example: In the cell AI10 labeled with "U", I would like a total of all numbers in the range c10:ag10 IF the cell under that number has an "U".

Example: In the cell AJ10 labeled with "V", I would like a total of all numbers in the range c10:ag10 IF the cell under that number has an "V".

2. ## Re: Sum with Criteria (2K3)

Try these formula:

<pre>=SUMPRODUCT(((C11:AG11="S")+(C11:AG11="A"))*C 10:AG10)

=SUMPRODUCT((--(C11:AG11="U"))*C10:AG10)

=SUMPRODUCT((--(C11:AG11="V"))*C10:AG10)
</pre>

3. ## Re: Sum with Criteria (2K3)

Thank you so much for your quick response. It was exactly what I needed.

4. ## Re: Sum with Criteria (2K3)

just wanted to add my thanks.

Managed to get a sum and a count working checking against 3 columns.

Big Help

5. ## Re: Sum with Criteria (2K3)

Congratulations. I am always happy when I don't just help someone get an answer, but learn how to get the answer.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•