Merge range in excel

[xlstime]

Hi Master,

Is there any way to merge any more than 2 ranges in excel and performer formula on it

 

[Ramesh]

Yes, you can refer to multiple ranges by a comma separator

For example: If you want to sum up the numbers available in A2:A11, B2:B11 and C2:C11, then you can write a formula as:

=SUM(A2:A11,B2:B11,C2:C11)

It should work in the same way for the other formulas too..

 

[xlstime]

Thanks Ramesh for your reply, i want to merge range then apply formula on it, for example i have list of x,y and z with 2 columns each name and value, now i want to merge range and put sumifs or sumif function to get result

 

[NARAYANK991]

Hi ,

I think what you are looking for may be discussed in this link ; go through the comments also.

https://excelxor.com/2015/07/03/redimensioning/

Narayan