LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Manos
 
Posts: n/a
Default Copy and SUM functions with different ranges

Dear all


I am attaching an excel file looking your help in two areas.
The first one is to copy a code from one cell to folloning cells with
different ranges. Eg. a code form A8 to A9till A15, a code form A25 to A26
till A32 and so on.


The second problem can be solved with a sumif. I have sum values eg from E10
to E15 and i want to have the sum to E16, then form E20 till to E32 to sumup
to E33 and so on.

The problem is that the file is uite big, exported from ERP and has 48000
lines

Any solution to any of the two problems would be great.

Thank you in advance
Manos




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 07:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"