Re: $$Excel-Macros$$ Re: Query on count

2014-11-15 Thread Kal xcel
Thank you all. It's really helped me a lot. Thanks in once again On Thu, Nov 13, 2014 at 6:24 PM, Mandeep Baluja rockerna...@gmail.com wrote: Hey Kalyan, check this array formula and the sheet. =COUNT(C4:R4)-COUNTIF(C4:R4,=0)-SUM(IF(ISNUMBER(SEARCH(.,C4:R4)),1,0)) Regards, Mandeep

$$Excel-Macros$$ Re: Query on count

2014-11-13 Thread sanjaiy yadav
Hi, PFA Solution, Regards Sanjai Kumar On Thursday, November 13, 2014 5:12:11 PM UTC+5:30, Kal xcel wrote: Dear Experts, Please help me to solve my query. Thanks in advance -- *Kalyan Chattopadhyay* *Executive Corporate MIS* *Joy Cosmetics* -- Are you =EXP(E:RT) or

$$Excel-Macros$$ Re: Query on count

2014-11-13 Thread Mandeep Baluja
Hey Kalyan, check this formula and the sheet . =COUNT(C4:R4)-COUNTIF(C4:R4,=0)-SUM(IF(ISNUMBER(SEARCH(.,C4:R4)),1,0)) Ctrl+shift+Enter Regards Mandeep Baluja On Thursday, November 13, 2014 5:12:11 PM UTC+5:30, Kal xcel wrote: Dear Experts, Please help me to solve my query. Thanks in

$$Excel-Macros$$ Re: Query on count

2014-11-13 Thread Mandeep Baluja
Hey Kalyan, check this array formula and the sheet. =COUNT(C4:R4)-COUNTIF(C4:R4,=0)-SUM(IF(ISNUMBER(SEARCH(.,C4:R4)),1,0)) Regards, Mandeep Baluja On Thursday, November 13, 2014 5:12:11 PM UTC+5:30, Kal xcel wrote: Dear Experts, Please help me to solve my query. Thanks in advance --