Excel Formula

[the_A_guest]

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" I
The Cells Of X3

Thank You So Much In Advance
Have A Nice Da

+-------------------------------------------------------------------
|Filename: HHELP.jpg
|Download: http://www.excelbanter.com/attachment.php?attachmentid=734
+-------------------------------------------------------------------

 

[lhkittle]

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|

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

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

 

[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

THANK YOU SOOOOO MUCH FOR YOUR HELP, YOU'RE AWERSOM

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