Nested Sumifs

[rossmcl]

Any help here would me much appreciated.<br>Can you do nested SUMIF's??<br><br>1&nbsp;&nbsp;&nbsp;A&nbsp;&nbsp;&nbsp;YES <br>2&nbsp;&nbsp;&nbsp;A&nbsp;&nbsp;&nbsp;YES<br>3&nbsp;&nbsp;&nbsp;A&nbsp;&nbsp;&nbsp;NO<br>4&nbsp;&nbsp;&nbsp;B&nbsp;&nbsp;&nbsp;YES<br><br>I WANT TO ADD UP ALL THE FIRST COLUMN WHERE:<br>2nd COLUMN = &quot;A&quot;<br>3RD COLUMN = &quot;YES&quot;<br><br>ie the answer should be 3<br><br>IS THIS POSSIBLE. ANY HELP MUCH APPRECIATED?<br>Ross McLanachan<br>

 

[blarosa]

Yes--as an array.&nbsp;&nbsp;Assuming the upper left cell is A1, use this formula:<br><br>SUM((B1:B4=&quot;A&quot*(C1:C4=&quot;Yes&quot*A1:A4)<br><br>And remember to enclose the formula with a ctrl-shift-enter to set up the function as an array.