Try this =SUMPRODUCT(--(B2:B32<0),--(B3:B33<0))
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Nikhil Shah Sent: Dec/Wed/2011 10:14 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help Dear Friend, I want to find out Consecutive Negative Return (%) in Times & Number Years : Answer is : 2 Times & 2 Years.... Now i want EXCEL Formula..I am using EXCEL 2003 ..No VBA Code...Pl help me .. Year Return Year Return 1980 28.86% 1996 4.24% 1981 49.56% 1997 13.31% 1982 3.56% 1998 -17.17% 1983 7.20% 1999 63.57% 1984 8.15% 2000 -20.99% 1985 100.95% 2001 -17.92% 1986 -1.34% 2002 4.44% 1987 -18.43% 2003 74.49% 1988 49.60% 2004 11.62% 1989 18.85% 2005 42.33% 1990 27.56% 2006 48.35% 1991 95.88% 2007 45.61% 1992 33.62% 2008 -51.22% 1993 27.94% 2009 76.35% 1994 17.51% 2010 17.43% 1995 -20.45% 2011 till 7th Dec. -17.71% Regards -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
MostImportant.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
