Try Sumif
Kantilal Badale
On Mon, Feb 27, 2012 at 6:02 PM, Arpita kapoor wrote:
> Hi,
>
> Can anyone please help me with a simple formula for the below data set.
> All I need is to a sum of all the figures (+/-) except for those which are
> =><1/-1
>
>0.47 0.40 0.26 1.05 0.21 2.50 0.0
Hi Arpita,
You can also use..
SUMPRODUCT((A1:A16>0)*(A1:A16))
On Mon, Feb 27, 2012 at 6:02 PM, Arpita kapoor wrote:
> Hi,
>
> Can anyone please help me with a simple formula for the below data set.
> All I need is to a sum of all the figures (+/-) except for those which are
> =><1/-1
>
>0.
Hi,
Try below formula with Ctrl+Shift+Enter.
=SUM(IF(A1:A16>0,A1:A16,0))
Find the attached file.
Regards,
MARIES.
On Mon, Feb 27, 2012 at 4:32 PM, Arpita kapoor wrote:
> =><
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titl
Hi,
Can anyone please help me with a simple formula for the below data set. All I
need is to a sum of all the figures (+/-) except for those which are =><1/-1
0.47
0.40
0.26
1.05
0.21
2.50
0.05
-0.03
-0.07
-0.08
-0.31
-0.48
-0.65
-0.66
-0.80
-11.26
I don't seem to get it, I am s
Can you please provide code for that?
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of sunil jagtap
Sent: 14 December 2011 18:05
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Urgent help needed on Slow Excel
gt; Regards,
> Amit Desai
>
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of Kiran Kancherla
> Sent: 14 December 2011 13:57
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance
&
half Of Kiran Kancherla
Sent: 14 December 2011 13:57
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance
Hi Amit,
I have copy the data and pasted the data in a new excel sheet.
It was working fine for me.
Please try.
Regards,
Kiran.
Sent o
.com
Date: Wed, 14 Dec 2011 00:25:49
To:
Reply-To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance
The link did not help
Dear Masters, please help me to improve performance of this sheet.
From: excel-macros@googlegroups.com [mailt
gt;> ===
>>> Don Guillett
>>> SalesAid Software
>>> dguille...@gmail.com
>>>
>>> *From:* Amit Desai (MERU)
>>> *Sent:* Tuesday, December 13, 2011 9:51 AM
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* $$Excel-
gt; *http://tinyurl.com/8749ypq*
>> ===
>> Don Guillett
>> SalesAid Software
>> dguille...@gmail.com
>>
>> *From:* Amit Desai (MERU)
>> *Sent:* Tuesday, December 13, 2011 9:51 AM
>> *To:* excel-macros@googlegroups.com
>> *Subject:*
id Software
> dguille...@gmail.com
>
> *From:* Amit Desai (MERU)
> *Sent:* Tuesday, December 13, 2011 9:51 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Urgent help needed on Slow Excel Performance
>
>
> Dear Friends,
>
>
>
> I
1033&id=254354&mkt=en-US
http://tinyurl.com/8749ypq
===
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Amit Desai (MERU)
Sent: Tuesday, December 13, 2011 9:51 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance
Dea
Did you try my solution??
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Anil Bhange
Sent: Thursday, October 27, 2011 11:49 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Urgent help needed
Hi Noorain,
Thanks for the help, but it is not working at my end due
t;> By all the means you can,
>> In all the ways you can,
>> In all the places you can,
>> At all the times you can,
>> To all the people you can,
>> As long as ever you can.” - John Wesley
>> *-
>>
>>
>> --
-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Urgent help needed
Seconding Don and Paul on that. Another point that comes to the table is the
lack of proper Subject Titles that clearly and concisely describes the
problem/objective. I know that this is hinted in the forum rules, but do we not
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Urgent help needed
Dear Anil,
Please try through below code and see attached sheet.
Sub Consodilated_sheet_withsheetname()
Dim i, j, k, s As Long
Dim x, y, z As Long
Application.ScreenUpdating = False
x = Sheet1.Cells(1, Columns.Count
"H").Interior.Color = vbCyan
> Next i
> .Columns.AutoFit
> .Rows(1).Delete
> End With
> Application.ScreenUpdating = True
> End Sub
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Anil Bhange
> *Sent:* Thursday,
you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: dguillett1
To: excel-macros@googlegroups.com
Sent: Thu, October 27, 2011 9:56:09 AM
Subject: Re: $$Excel-Macros$$ Urgent help needed
Anil, Pl
vbCyan
Next i
.Columns.AutoFit
.Rows(1).Delete
End With
Application.ScreenUpdating = True
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Anil Bhange
Sent: Thursday, October 27, 2011 5:24 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Urgent help neede
This helps . Thank you much.
On Sun, Jul 31, 2011 at 1:18 AM, ashish koul wrote:
> Try this see if it helps
>
>
> On Sun, Jul 31, 2011 at 12:18 AM, Sara Lee wrote:
>
>> hello
>>
>> i need to combine multiple excel files(15) into one excel file. Each file
>> has 2 sheets... R and S and data fro
Try this see if it helps
On Sun, Jul 31, 2011 at 12:18 AM, Sara Lee wrote:
> hello
>
> i need to combine multiple excel files(15) into one excel file. Each file
> has 2 sheets... R and S and data from both needs to consolidated into
> respective sheets. .. so i need a macro which can give one f
hello
i need to combine multiple excel files(15) into one excel file. Each file
has 2 sheets... R and S and data from both needs to consolidated into
respective sheets. .. so i need a macro which can give one file with two
sheets that consolidate data from all the files... All the files have sam
Hi Avinash,
Try below Links,
http://www.l3analytics.com/2011/05/16/free-excel-dashboard-template/
http://www.excelcharts.com/blog/how-to-create-an-excel-dashboard/
http://www.contextures.com/excel-dashboards.html
http://www.mrdashboard.com/download.html
--
*Best Regards,*
*Venkat*
*
*
On Thu,
Hi Avinash,
Try this:
http://www.freeexceldashboards.com/exceldashboardtemplates.html
Cheers,
Andy
On Thu, Jul 21, 2011 at 4:49 PM, Avinash Patil wrote:
> Hi Masters,
>
> can anybody please forward me excel dashboard designs i need dashboard
> designs with all automations and vba work like dro
open this link
http://chandoo.org/wp/excel-dashboards/
On Thu, Jul 21, 2011 at 4:49 PM, Avinash Patil wrote:
> Hi Masters,
>
> can anybody please forward me excel dashboard designs i need dashboard
> designs with all automations and vba work like drop downs , charts, graphs
> "a dashboard with fu
Hi Masters,
can anybody please forward me excel dashboard designs i need dashboard
designs with all automations and vba work like drop downs , charts, graphs
"a dashboard with full graphical and customization interface"
i'll be realy greatfull to you guys please forward me the designs,
Regards,
Thanx Aindril,
I appreciate.
Only that it's doing the reverse, it's finding sum for those who attempted
less than 8 subjects.
What I wanted is it finding sum if only one atempted either 8 or more
subjects
the sum found should be for the least 8 subjects of all the attempted
e.g 1) If some one attem
the columns in total are over 15 so if more than 8 columns have data in them
I want to get a sum of th least 8, but if only 7 columns have data then the
sum shoulld not be put in.
coz what might happen is if some one attempted only 3 subjects it might
compute his sum which i don't want.
On 2 Novem
Hi,
It looks like your calculations are not working as you are Displaying the
numbers as text. For Example:
The following Formula:
=
IF(sheet1!Q2>74,"1",IF(sheet1!Q2>69,"2",IF(sheet1!Q2>64,"3",IF(sheet1!Q2>59,"4",IF(sheet1!Q2>49,"5",IF(sheet1!Q2>44,"6",IF(sheet1!Q2>39,"7",IF(sheet1!Q2>29,"8",IF(sh
Hi Ayoub,
Can you please explain this:
Of these columns some lack data if less than 8 of the above columns lack
data word "missed" should appear
Regards,
Andy
On Tue, Nov 2, 2010 at 3:20 PM, ayoub Kakande wrote:
> Good afternoon
> I need some help on a project that is buzzing ma head
> attach
derstand it. Can you
>> > explain it.
>> >
>> > Regards,
>> >
>> > Swapnil.
>> >
>> > On Sat, Jun 26, 2010 at 4:52 PM, Dilip Pandey
>> wrote:
>> >
>> >> Thanks Dave...!!!
>> >>
>> >> --
>&
it.
> >
> > Regards,
> >
> > Swapnil.
> >
> > On Sat, Jun 26, 2010 at 4:52 PM, Dilip Pandey
> wrote:
> >
> >> Thanks Dave...!!!
> >>
> >> --
> >> Thanks & Regards,
> >>
> >> DILIP KUMAR PANDEY
> >>
>>
>> On 6/26/10, Dave Bonallack wrote:
>> >
>> > Hi Dilip,Excellent solution!Regards - Dave
>> >
>> > Date: Fri, 25 Jun 2010 16:48:57 +0530
>> > Subject: Re: $$Excel-Macros$$ Urgent Help needed regarding using macro
>> > From: dilipan...@g
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 62, India
>
>
> On 6/26/10, Dave Bonallack wrote:
> >
> > Hi Dilip,Excellent solution!Regards - Dave
> >
> > Date: Fri, 25 Jun 2010 16:48:57 +0530
> > Subject: Re:
0 16:48:57 +0530
> Subject: Re: $$Excel-Macros$$ Urgent Help needed regarding using macro
> From: dilipan...@gmail.com
> To: excel-macros@googlegroups.com
> CC: mathan4s...@gmail.com
>
> Hi Mathan,
>
> Attached file has been solved per your requirements. Please let me know i
Hi Dilip,Excellent solution!Regards - Dave
Date: Fri, 25 Jun 2010 16:48:57 +0530
Subject: Re: $$Excel-Macros$$ Urgent Help needed regarding using macro
From: dilipan...@gmail.com
To: excel-macros@googlegroups.com
CC: mathan4s...@gmail.com
Hi Mathan,
Attached file has been solved per your
You are welcome Mathan...!! :)
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On Fri, Jun 25, 2010 at 6:44 PM, Mathan wrote:
> Thanks a lotSimply great!!!
>
>
> On Fri, Jun 25, 2010 at
Thanks a lotSimply great!!!
On Fri, Jun 25, 2010 at 6:12 PM, Dilip Pandey wrote:
> Hey Aindril thanks for your encouraging words... :)
>
> --
> Thanks & Regards,
>
> DILIP KUMAR PANDEY
> MBA-HR,B.Com(Hons),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New
Hey Aindril thanks for your encouraging words... :)
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On Fri, Jun 25, 2010 at 5:38 PM, Aindril De wrote:
> Hi Dilip,
>
> This is an excelle
Hi Dilip,
This is an excellent solution you have provided.. Hats off to you for
keeping it so simple..
Cheers,
Andy
On Fri, Jun 25, 2010 at 4:48 PM, Dilip Pandey wrote:
> Hi Mathan,
>
> Attached file has been solved per your requirements. Please let me know if
> it solves your problem else ge
Hello Experts,
Thank you very much for helping me on my earlier queries.
Could you please help me in finding cells which contains multibyte
characters.
I mean how can we find or select the cells which contains NON-English
charecters.
We get the data from almost each country in this world to work o
I had almost completed my VBA project and then decided to convert it to
stand alone exe file using VB6 so that I can register my custom type data
files to have a specific Icon and enable them to be opened with my
application on doubleclick.
I have converted most of it successfully but just now I a
Thanks Vinod and Dave for ur help. I appreciate all ur
effortshowever...this still does not allow me to write new macro
or make changes in the macros in this excel file. it still asks for a
VBA password for same. Plz see if u guys can crack that password for
me or let me knw how to do this.
On
hi sheetal!
why dont u copy the entire sheet.. and paste it on another (unprotected
sheet)..
a bit silly suggestion.. just chk if it works for u..
u wont atleast loose the working..
Regards,
Anubhav
On Sat, Nov 21, 2009 at 7:15 AM, sheetal lakhotia wrote:
> Hi Friends,
>
> Is there anyway to
send file
On Sat, Nov 21, 2009 at 7:29 AM, sheetallakho...@gmail.com <
sheetallakho...@gmail.com> wrote:
> Hi Friends,
>
> Is there anyway to remove or crack the VBA password from the an excel
> file. As soon as u double click to open the file. It gives a message
> that Enter password for write a
Hi, If you can open the file in Read-only mode, then do so, make the changes
you want, then Save As whatever name you want. Then just delete the original.
Regards - Dave
> Date: Fri, 20 Nov 2009 17:59:46 -0800
> Subject: $$Excel-Macros$$ Urgent Help Needed
> From: sheetallakho...@gmail
Hi Friends,
Is there anyway to remove or crack the VBA password from the an excel
file. As soon as u double click to open the file. It gives a message
that Enter password for write access or open read only.
My colleague who created this sheet has forgot the password and we
need to make changes in
I have few cells in excel worksheet that I want to show as header in print
copy. Can any one tell me how to select those cells to show as print header.
Regards
Mahreen
--~--~-~--~~~---~--~~
--
hi excelers ,hi nishant
i want to add the radio buttons dynamically where it looks for a DNA marker
and like suppose
Suppos I want a radio button to appear incells e13 ,e16 and e18 i have
given 3 markers I HAVE to loop thro .bcoz i dont know how many more
radio buttons i need plz c
49 matches
Mail list logo
