Hi Anil,
Use this formula for calculating the positive value only in a row:
=SUMIF(B1:D1,">0",B1:D1)
Where B1 = 30 , C2= -20 & D2 = 60.
Hope this will help you.
Regards,
Deepak Rai
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of AN
Hi Tauseef,
Thanks for the encouraging words.
For other columns, you just need to change the range (references) and press
Ctrl+Shift+Enter (to enforce array).
If you still face any challenge, please attach the sample spreadsheet.
Thanks,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +
Attached is the solution
_
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of ANIL NAIR
Sent: Friday, August 07, 2009 2:11 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ urgent - How to calculate sum of only positive
numbers
excel sh
Hi Dilip !
I have checked sheet , formula is perfect( sum and If
combination) but it doesn't work for other columns ...please explane...
Many thanks !
On Fri, Aug 7, 2009 at 3:09 PM, Dilip Pandey wrote:
> Hi Anil,
> Solved sheet is attached with this email. Thanks
> --
Or simply use the SUMIF function as in the attached doc.
On 8/7/09, Dilip Pandey 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
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 edi
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 {} (bracke
Hi,
U can try this
=SUMIF(E4:E8,">0",E4:E8)
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of ANIL NAIR
Sent: 07 August 2009 PM 02:09
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ urgent - How to calculat
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 wrote:
>
> excel sheet is attached
>
> -- Forwarded me
