Excel 2007 if and function Closed

Question

Hello, 

It sound simple but i can't figure it out..


I have 3 cels and i wanne have 1 value

example

A		B		C
33572		SNAKE		365
33572		SUGGER	                366	
33572		SALT		367

i want to combine A B to result C

how can i do this?

thanks

Saman.tha · Answer

I hope I didn't get it wrong. Juste type into C1: =A1+B1 and tap enter. Afterwards you can copy it (just drag) to all the other cells in the C column. The formula will automatically adapt to the number of the row like =A2+B2 or =A3+B3 ....

jb · Answer

Is not like that 

sheet 1 

A- B- C- 
621- 308043- EIG 
621- 308044- OPBEH 
621- 308045- GEBR 
622- 308046- EIG
622- 308047- OPBEH
622- 308048- GEBR
623-308049- EIG
623-308050- GEBR
623-308051- OPBEH


Sheet 2 
A B 
621 ? 
622 ? 
623 ? 


on the second sheet I have the number 621 

need de number from B combine if A combine with C on sheet 1 

and have number 621 on collum A on the second sheet. 

so how can i have Number on kolom B on the second sheet IF i only want it from EIG? 

if i have more than 1000 numbers under each other.

Excel 2007 if and function

2 responses

Similar discussions

Subscribe To Our Newsletter!