excel function help

Jecht · 09-22-2007, 01:39 PM

Hi everybody! I need your help with ms excel: i have datas stored in 2 columns, the first is filled with letters (values allowed are null, "a" or "r") while the second with numbers. What i want to do is to sum all the numbers in the rows of the 2nd column where the value in the 1st column is "r" on the same row.
I hope you understand what i need to do, and help me out, thanks! =)

OK: i found out how to get that...

But if need not to sum, but do this:

IF ((the value in the rows of the second column where the value on the same row in the 1st column is "a" are >4) OR (the value in the rows of the second column where the value on the same row in the 1st column is "r" are >2)) THEN do this ELSE do that

to better explain i'll do like this in php:

PHP Code:


			
$column1=array("a","r","r","a","a","r","a","r","a","r");
$column2=array(2,3,1,3,2,3,6,,1,2,0);

foreach($column2 as $key => $value){
   if ($column1[$key]='a'){
      if ($value>4){ print("Error: some \"a\" are >4"); }
   }else{
      if ($value>2){ print("Error: some \"r\" are >2"); }
   }
}

Well... in this case there isn't an OR, but it's fine anyway...

09-22-2007, 01:39 PM	#1 (permalink)
Jecht New Member Join Date: Jul 2007 Location: Livorno, Italy Age: 21 Posts: 15	excel function help Hi everybody! I need your help with ms excel: i have datas stored in 2 columns, the first is filled with letters (values allowed are null, "a" or "r") while the second with numbers. What i want to do is to sum all the numbers in the rows of the 2nd column where the value in the 1st column is "r" on the same row. I hope you understand what i need to do, and help me out, thanks! =) OK: i found out how to get that... But if need not to sum, but do this: IF ((the value in the rows of the second column where the value on the same row in the 1st column is "a" are >4) OR (the value in the rows of the second column where the value on the same row in the 1st column is "r" are >2)) THEN do this ELSE do that to better explain i'll do like this in php: PHP Code: `$column1=array("a","r","r","a","a","r","a","r","a","r"); $column2=array(2,3,1,3,2,3,6,,1,2,0); foreach($column2 as $key => $value){ if ($column1[$key]='a'){ if ($value>4){ print("Error: some \"a\" are >4"); } }else{ if ($value>2){ print("Error: some \"r\" are >2"); } } }` Well... in this case there isn't an OR, but it's fine anyway... __________________ Mobo Asus P4P800 Intel P4 HT 2.8GHz 1536MB PC3200 DDR SDRAM Abit Siluro nVidia GeFORCE FX5600 256DDR Maxtor 200GB uATA/133 7200rpm sATA Raid0 Volume 500GB aDSL 2+ Last edited by Jecht; 09-22-2007 at 02:16 PM. Reason: new problem

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Function Key wont work (Sony Vaio PCG-K86P)	sotos	Sound Cards and Speakers	1	08-06-2007 05:24 AM
Excel 2003 Question, please help a Newbie	jaes	General Software	4	04-12-2007 02:40 AM
Help with IF function of excel	psaila	General Software	1	06-01-2006 09:39 PM
Alright, I AM FED UP WITH THIS!	Darkomen	Desktop Computers	45	10-18-2005 09:20 AM
Linking Access and Excel	Ryad	General Software	1	12-06-2004 03:47 PM