Thanks a lot everyone for your quick help. This is one of the best forums for Advance Excel.
Azeema On Jul 20, 2:42 pm, Haseeb Avarakkan <haseeb.avarak...@gmail.com> wrote: > Hello Azeema, > > Use this formula, say in V2 & copy down. > > =COUNTIFS(A2:S2,"Yes",B2:T2,"<>Yes") This will only work XL2007 or later. > > If you want to work with XL 2003 or prior use SUMPRODUCT > > =SUMPRODUCT(--(A2:S2="Yes"),--(B2:T2<>"Yes")) > > See the attached > > HTH > Haseeb > > UnpaidWork with COUNTIFS.xlsx > 13KViewDownload -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel