ExcelBanter - Excel Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel Formula (https://www.excelbanter.com/excel-discussion-misc-queries/448014-excel-formula.html)

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

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

Quote:

Originally Posted by (Post 1608716)

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