Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
stge
 
Posts: n/a
Default Adding column data


I have a column 'A' in which there is a number representing the number
of days
the event takes.

in the next 7 columns are a set of numbers representing number
of events happening on that day, (columns B_H)

in the next 7 columns (I-O) is where I want the result so that should
the number
of days in column 'A' be greater than 1 then the result carries over to
the
next column adding up any event that is happening on that day (from
the events per day columns).

Event
Type # of Events per day Result required
# of days B C D E F G H I J K L M N O
1 2 0 2 2 0 0 0 2 0 2 2 0 0 0

2 4 4 0 0 0 0 0 4 8 4 0 0 0 0

4 0 5 0 0 0 0 0 0 5 5 5 5 0 0

Any help or suggestions would be appreciated, I am using v2002 Excel
Many thanks
stge


--
stge
------------------------------------------------------------------------
stge's Profile: http://www.excelforum.com/member.php...o&userid=16068
View this thread: http://www.excelforum.com/showthread...hreadid=275223

  #2   Report Post  
Bernie Deitrick
 
Posts: n/a
Default

stge,

Assuming your table is in A1:H4, in cell I2, use the formula

=SUM(OFFSET(B2,0,0,1,MAX(-(COLUMN(B2)-1),-$A2)))

and copy to I2:O4.

HTH,
Bernie
MS Excel MVP

"stge" wrote in message
...

I have a column 'A' in which there is a number representing the number
of days
the event takes.

in the next 7 columns are a set of numbers representing number
of events happening on that day, (columns B_H)

in the next 7 columns (I-O) is where I want the result so that should
the number
of days in column 'A' be greater than 1 then the result carries over to
the
next column adding up any event that is happening on that day (from
the events per day columns).

Event
Type # of Events per day Result required
# of days B C D E F G H I J K L M N O
1 2 0 2 2 0 0 0 2 0 2 2 0 0 0

2 4 4 0 0 0 0 0 4 8 4 0 0 0 0

4 0 5 0 0 0 0 0 0 5 5 5 5 0 0

Any help or suggestions would be appreciated, I am using v2002 Excel
Many thanks
stge


--
stge
------------------------------------------------------------------------
stge's Profile:

http://www.excelforum.com/member.php...o&userid=16068
View this thread: http://www.excelforum.com/showthread...hreadid=275223



Reply
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with data not getting plotted Scott Ehrlich Excel Discussion (Misc queries) 2 January 25th 05 06:17 AM
find rows for unique data in 1 column and different data in other. Dot Majewski Excel Discussion (Misc queries) 1 January 21st 05 01:23 AM
How do I compare data in two different spreadsheets i.e. (column . inspector gadget Excel Discussion (Misc queries) 1 December 29th 04 06:40 PM
Running Data Table using an input that triggers DDE linked data [email protected] Excel Discussion (Misc queries) 1 December 16th 04 12:56 PM
macro - adding rows to a column that is summed HGood Excel Discussion (Misc queries) 2 December 1st 04 04:28 PM


All times are GMT +1. The time now is 03:14 AM.

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

About Us

"It's about Microsoft Excel"