U can do control+shift+enter instead of normal enter

 

Regards

Sathish Jalendran

 

From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Ashish Pradhan
Sent: 07 August 2009 PM 02:46
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: urgent - How to calculate sum of only positive
numbers

 

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,""))} work fine
but the moment i click to edit on the cell where this formula is entered,
the {} (brackets) disappear even if i dont make any changes and I get an
error on this formula.Copy pasting this formula works fine. 

Any idea why this could be?

Thanks
-- 
Ashish

"The older we get, the more we needs people around us who knew us when we
were young" -- Unknown 



On 8/7/09, Dilip Pandey <dilipan...@gmail.com> wrote:

Hi Anil,

Solved sheet is attached with this email.  Thanks

-- 
DILIP KUMAR PANDEY  
  MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062

On Fri, Aug 7, 2009 at 2:10 PM, ANIL NAIR <anil.nair1...@gmail.com> wrote:


excel sheet is attached 


---------- Forwarded message ----------
From: ANIL NAIR <anil.nair1...@gmail.com>
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
and negative numbers. excel sheet is attached

 

PLS TREAT THIS AS URGENT

 

regds

anil nair

 

 



















The information contained in this electronic message and any attachments to 
this message are intended for the exclusive 
use of the addressee(s) and may contain proprietary, confidential or privileged 
information. If you are not the intended
 recipient, you should not disseminate, distribute or copy this e-mail. Please 
notify the sender immediately and destroy
 all copies of this message and any attachments contained in it.


--~--~---------~--~----~------------~-------~--~----~
----------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~----------~----~----~----~------~----~------~--~---

Reply via email to