Formulae Help Please

[Guest]

Hi - I'm a newbie and Im having trouble with a spreadsheet at wor
On page 1 I have data for how much customers have paid us on which dates e.g

1Jan03 8Jan03 15Jan03 22Jan03............................................................31Dec0
Customer A £100 £150 £10

Customer B £100 £20

Customer C £500 £20

On page 2 I have a summary page with an entry for each customer,the total transactions outstanding and I need to get a formulae to work out the total amount over 60 days old for each customer on page 1. I have a cell which gives me todays date and one that works out the date 60 days ago but i can't work out how to get my sum to stop at that date.

Total amount outstanding Amount over 60 days ol
Customer A =SUM('page1'!3:3
Customer B =SUM('page1'!5:5
Customer C =SUM('page1'!7:7

Today(
Today()-6

Any help would be very much appreciated

 

[Frank Kabel]

Hi
for customer A try the following (row 1 contains your dates, column A
the customer name and column B the first date)
=SUM(OFFSET($A$3,0,MATCH(TODAY()-60,B1:X1),1,13))

 

[Guest]

Thanks Frank - Your a star

----- Frank Kabel wrote: ----

H
for customer A try the following (row 1 contains your dates, column
the customer name and column B the first date
=SUM(OFFSET($A$3,0,MATCH(TODAY()-60,B1:X1),1,13)

-
Regard
Frank Kabe
Frankfurt, German

Swoop wrote