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
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
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
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
--