Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel Formula
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula
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 |
#3
|
|||
|
|||
Quote:
THANK YOU SOOOOO MUCH FOR YOUR HELP, YOU'RE AWERSOME |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Formula Guidance. Formula need to determine if cell is popul | Excel Programming | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Excel Formula Doesn't Execute (Shows formula-not the calcuation) | Excel Discussion (Misc queries) | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions |