Adding column data

[stge]

Hi Bernie,
Thanks for your reply, just got the books out to see what you hav
done. It works for the first row but not after that. The results nee
to be put into 7 columns say I to O and for 8 rows (I10:O17) with eac
row having a seperate event type and number of events per day. Th
results being the last 7 digits in the origional post (columns I-O).

Thanks again, if you have any other suggestions please let me know.

Regards
stg

 

[Bernie Deitrick]

stge,

The formula worked for the three rows of example data that you posted.

In I10, did you use the formula?

=SUM(OFFSET(B10,0,0,1,MAX(-(COLUMN(B10)-1),-$A10)))

Try it, and copy down and over to produce your final range.

HTH,
Bernie
MS Excel MVP