- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2007 August
- sum a range if two conditions are met

Subject: | sum a range if two conditions are met |

Posted by: | Valerie |

Date: | Tue, 14 Aug 2007 |

I would like to sum the numbers in a column that coincide with the rows where

the numbers in two other columns meet a certain condition.

For example, I need to find all rows where column A and column B have a

value of one; then the corresponding values for those rows in column C need

to be summed. I thought this may be a sumif formula, however I don't know if

more than one function can be nested in a sumif formula.

Any help with this would be greatly appreciated.

--

Valerie

- RE: sum a range if two conditions are met posted by Mike H on Tue, 14 Aug 2007
- RE: sum a range if two conditions are met posted by Farhad on Tue, 14 Aug 2007