Originally Posted by

On Friday, January 18, 2013 6:58:39 AM UTC-8, the_A_guest wrote:
Hello Dear Community Friends,



I Need Your Help,

I Need An Excel Formula



To Calculate The Sum Of All The Cells In X2 That Corresponds To "No" In

The Cells Of X3



Thank You So Much In Advance

Have A Nice Day





+-------------------------------------------------------------------+

|Filename: HHELP.jpg |

|Download: http://www.excelbanter.com/attachment.php?attachmentid=734|

+-------------------------------------------------------------------+







--

the_A_guest

Where X2 is in column K and X3 is in column L:

=SUMIF(L2:L10,"NO",K2:K10)

X2 X3
23 YES
45 NO
78 YES
90 YES
38 NO
61 NO
23 NO
74 NO
8 YES

Regards,
Howard