Nest SumIf

Hello. I am trying to use a formula that will sum a colum if the
criteria in one column equals a cell and the criteria in another
column equals another cell.

Example:

=SUMIF($A$11:$A$10000,$A$1,SUMIF($B$11:$B$10000,A3 ,$O$10000))

This funtion does not work, but it gives an idea of what I need to
do. Any idea how to make this happen?

Thanks

Sorry, I missed an element of the final string of the formula. It
would read like below:

=SUMIF($A$11:$A$10000,$A$1,SUMIF($B$11:$B$10000,A3 ,$O$11:$O$10000))

Thanks again

Hi,

Depending on exactly what you are trying to do you probably can't do a
multi-condition SUMIF unless you are using Excel 2007, in which case look at
the SUMIFS function.

In 2003 and earlier we would use an array SUM or SUMPRODUCT function to do
this:

=SUMPRODUCT(($A$11:$A$10000=$A$1)*($B$11:$B$10000= A3)*($O$11:$O$10000))

There are other variations of this, but this is a start.
--
Cheers,
Shane Devenshire


" wrote:

Sorry, I missed an element of the final string of the formula. It
would read like below:

=SUMIF($A$11:$A$10000,$A$1,SUMIF($B$11:$B$10000,A3 ,$O$11:$O$10000))

Thanks again

Thank you