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

Comments Format:






Change Mode
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:







Add Vote
8 comments
Rate Comments: Nested
malay321
Associate

Join Date: May 2009
Posts: 32

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.
Register to Reply
Pathfinder Tags: excell.........;;
Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.

"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, vote them!
edignan
Guru
Engineering Fields - Systems Engineering - New Member Popular Science - Weaponology - New Member

Join Date: Jun 2006
Location: Borrego Springs
Posts: 2636
Good Answers: 62
#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.

__________________
 "If you want to get somewhere else, you must run at least twice as fast as that!"
Register to Reply
Anonymous Poster
#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.
Register to Reply
Graebeard
Power-User
Engineering Fields - Electrical Engineering - New Member

Join Date: Aug 2007
Location: Toronto
Posts: 239
Good Answers: 9
#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
Register to Reply
babybear
Guru
United Kingdom - Member - Not a new member!

Join Date: Jun 2008
Location: USA/Europe
Posts: 4547
Good Answers: 68
#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 it easy, bb. >"HEAR & you FORGET<>SEE & you REMEMBER<>DO & you UNDERSTAND"<=$=|O|=$=>"Common Sense is Genius dressed in its Working Clothes"<>[Ralph Waldo Emerson]
Register to Reply
d_m_rosenberg
Power-User

Join Date: Feb 2008
Location: Cleveland, OH
Posts: 135
Good Answers: 6
#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
Register to Reply Score 1 for Good Answer
No more "Almost" Good Answers.
Anonymous Poster
#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.
Register to Reply Off Topic (Score 5)
Lendog
Power-User

Join Date: Jun 2007
Posts: 141
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.
Register to Reply
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: 368
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
Register to Reply
Register to Reply
Have a Different Question?
8 comments

"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, vote them!
Copy to Clipboard

Users who posted comments:

Anonymous Poster (2); babybear (1); d_m_rosenberg (1); edignan (1); Graebeard (1); kkjensen (1); Lendog (1)

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

Advertisement

Got Something to Say?
Ask a Question
Start a Discussion

Search this Forum
Software & Programming:
Go

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

Site Directories
Forum Directory
Blog Directory
User Group Directory
RSS Feeds

CR4 Rules of Conduct
CR4 FAQ
Site Glossary

Who's Online (85 right now)
Show Members
Advertisement