Tell a Friend About CR4
Engineering Toolbar
Search GlobalSpec
Login | Register
Home | Software & Programming | Software & Programming | Microsoft Excel Formulas

Previous in Forum: how to send html message from outlook express?   Next in Forum: Microsoft Excel Workbooks
Close

Comments Format:






Close

Subscribe to Discussion:

CR4 allows you to "subscribe" to a discussion
so that you can be notified of new comments to
the discussion via email.

Close

Rating Vote:







8 comments
Subscribe Rate this Comments: Nested
malay321
Active Contributor

Join Date: May 2009
Posts: 23

Microsoft Excel Formulas

05/19/2009 9:25 AM

I want to sum automatically the contents of one column ( Suppose column A and row 3 ) depending upon the condition of other column ( Suppose column B and row 3 ) of Microsoft Office Ex cel .The numbers column are not fixed. The data impoted to Ex cel from other software ( Dewe soft 6.6 ). I want to make tamplate. Please help me by suggesting the script.
Send to a friend Digg this Add to del.icio.us
Pathfinder Tags: excell.........;;
Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.

Comments rated to be "almost" Good Answers:

Check out these comments that don't yet have enough votes to be "official" good answers and, if you agree with them, rate them!
edignan
Guru
Engineering Fields - Software Engineering - New Member Popular Science - Weaponology - New Member

Join Date: Jun 2006
Location: I'm north of San Diego, the better half joins me in a week.
Posts: 2306
Good Answers: 48
#1

Re: Microsoft Excel Formulas

05/19/2009 10:16 AM

I'll do you better

Learn VBA and make Excel dance and sing!

Seriously some of what you want to do is best done in VBA. Much more powerful than standard script.

__________________
Unintended consequences rule when busybodies get on their "high horses" - Emmett
Guest
#2

Re: Microsoft Excel Formulas

05/19/2009 10:40 AM

While on the Excel document, press F1 key for Excel help and how-to.
Graebeard
Power-User
Engineering Fields - Electrical Engineering - New Member

Join Date: Aug 2007
Location: Toronto - Picture from Lake Superior
Posts: 186
Good Answers: 6
#3

Re: Microsoft Excel Formulas

05/19/2009 1:46 PM

VBA is a great way to do this, but if it's relatively simple it can be done as array formulas. Why don't you give us an example table or spreadsheet and we can better help you.

Definitely do-able

Graebeard
babybear
Guru

Join Date: Jun 2008
Location: USA/Europe
Posts: 3976
Good Answers: 70
#4

Re: Microsoft Excel Formulas

05/20/2009 1:40 AM

Hello malay321,

Check this out

http://www.google.com/search?client=safari&rls=en-us&q=Microsoft+Excel+Formulas&ie=UTF-8&oe=UTF-8

Good luck and keep in touch...................

bb

__________________
Take care, bb ----- >> "HEAR & you FORGET <-> SEE & you REMEMBER <-> DO & you UNDERSTAND" << =$=|O|=$= >> "Common Sense is Genius dressed in its Working Clothes" << <> [Ralph Waldo Emerson]
d_m_rosenberg
Commentator

Join Date: Feb 2008
Location: Cleveland, OH
Posts: 85
Good Answers: 3
#5

Re: Microsoft Excel Formulas

05/20/2009 7:24 AM

There are ways you can do this without learning VBA (although that is not a bad idea). You can use 'SUMIF' statement to do this, it just depends on the specfics of your situation. With more information you will get a more specific and helpful answer.

__________________
If you want to know what God thinks of money, just look at the people he gave it to. - Dorothy Parker
Score 1 for Good Answer
No more "Almost" Good Answers.
Guest
#6

Re: Microsoft Excel Formulas

05/20/2009 8:03 AM

for your smart answer but how I increase the row number in SUMIF condition as it is very easy For loop in 'C' language.

int i,b=0;

int a[65536][65536],c[65536][65536];

for (i=0, i< 65536, i++)

{

if(c[2][i]> 600)

{

b= b+a[1][i];

}

}

end;

this value of 'b' is content of one cell in ex cell sheet.
Off Topic (Score 5)
Lendog
Power-User

Join Date: Jun 2007
Posts: 137
Good Answers: 2
#7

Re: Microsoft Excel Formulas

05/20/2009 10:35 AM

Try an array formula. Check out http://www.mrexcel.com/articles/CSE-array-formulas-excel.php. This site is fairly detailed in it's explanation, and has lots of info about excel.
kkjensen
Power-User
Canada - Member - BC Born, Alberta Raised, Quebec (poutine) crazed... Engineering Fields - Aerospace Engineering - An airplane is just a bunch of beams... Hobbies - Model Rocketry - Had fun as a kid...fun stuff Hobbies - CNC - dreaming of cutting Engineering Fields - Control Engineering - PID ME!

Join Date: Aug 2006
Location: Montreal, CANADA
Posts: 365
Good Answers: 10
#8

Re: Microsoft Excel Formulas

05/20/2009 10:37 AM

I would really really really recommend dropping the question on mrexcel.com ...their forum is absolutely phenomenal and filled with guru's that still make my head spin (and I'm the guy everyone comes and asks for help at the office).

__________________
kkjensen
8 comments
Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.

Comments rated to be "almost" Good Answers:

Check out these comments that don't yet have enough votes to be "official" good answers and, if you agree with them, rate them!
Copy to Clipboard

Users who posted comments:

babybear (1), d_m_rosenberg (1), edignan (1), Graebeard (1), Guest (2), kkjensen (1), Lendog (1)

Previous in Forum: how to send html message from outlook express?   Next in Forum: Microsoft Excel Workbooks
You might be interested in: Desktop Personal Computers, Notebook and Laptop Computers, Bus Analysis Software


"You say I started out with practically nothing, but that isn't correct. We all start with all there is. It's how we use it that makes things possible." -- Henry Ford

All times are displayed in US/Eastern (EST) (Register to change time zone)

©2005-2009 GlobalSpec. All rights reserved.
GlobalSpec, the GlobalSpec logo, SpecSearch, The Engineering Search Engine
and The Engineering Web are registered trademarks of GlobalSpec, Inc.
CR4 and Conference Room 4 are registered trademarks of GlobalSpec, Inc.
No portion of this site may be copied, retransmitted, reposted, duplicated or
otherwise used without the express written permission of GlobalSpec Inc.
350 Jordan Rd, Troy, NY, 12180

Got Something to Say?


Search this Forum
Software & Programming:

Search all of CR4

CR4 Sections
Automotive
BioMech & BioMed
Chemical & Material Science
Civil Engineering
Communications & Electronics
Education
Electrical Engineering
Engineering Careers
General
Instrumentation
Manufacturing
Mechanical Engineering
New Technologies & Research
Software & Programming
Sustainable Engineering

Site Indices
Forum Index
Blog Index
User Group Index
RSS Feeds
CR4 Store

CR4 FAQ
Site Glossary

Who's Online (146 right now)
Show Members