Previous in Forum: how to send html message from outlook express?   Next in Forum: Microsoft Excel Workbooks
Close
Close
Close
8 comments
Rate Comments: Nested
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!
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
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
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
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
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)
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
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 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