Hi Ashish,
Press CTRL+ENTER in the cell because this is an array formula.
Regards,
Deepak Rai
Sirjee
One additional help required on ur solved work sheet regarding the problem
by Anilji. Noticed what i feel is strange behaviour.
I use Excel2007. Your formula with {=SUM(IF(E4:E8>0,E4:E8,
excel sheet is attached
-- Forwarded message --
From: ANIL NAIR
Date: 7 Aug 2009 14:09
Subject: urgent - How to calculate sum of only positive numbers
To: excel-macros@googlegroups.com
Hi
URGENT HELP
I want to calculate the sum of only postive numbers in a row of both postive
an
Hi
URGENT HELP
I want to calculate the sum of only postive numbers in a row of both postive
and negative numbers. excel sheet is attached
PLS TREAT THIS AS URGENT
regds
anil nair
--~--~-~--~~~---~--~~
-
