Nest SumIf

  • Thread starter Thread starter nybaseball22
  • Start date Start date
N

nybaseball22

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.
 
Back
Top