Using SUMIF Function
I am switching from Excel and currently use the SUM(IF) Function to find the sum when two conditions are met. This is the formula I currently use in Excel:
=SUM(IF($I$1:$I$20=$B35,IF($J$1:$J$20=J$1,$K$20:$K$65,0),0))
This function finds a sum of the cells in the range $K$20:$K$65 if two conditions are met: if any of the cells in the range $I$1:$I$20 are equal to B35 AND also if any of the cells in the range $J$1:$J$20 are equal to J1.
When I use this formula in Numbers I get an error. Is there a function in Numbers to use for this type of Sums?
=SUM(IF($I$1:$I$20=$B35,IF($J$1:$J$20=J$1,$K$20:$K$65,0),0))
This function finds a sum of the cells in the range $K$20:$K$65 if two conditions are met: if any of the cells in the range $I$1:$I$20 are equal to B35 AND also if any of the cells in the range $J$1:$J$20 are equal to J1.
When I use this formula in Numbers I get an error. Is there a function in Numbers to use for this type of Sums?
MacBook Pro, Mac OS X (10.5.6)
