Formula Help
 

sheet1
Column A contains a list of dates. Formatted 18-Jan-2005
Column B a list of values Formatted as dollars

Sheet2
In column a Starting at a2 there is a list of weekending dates, Formatted 18-Jan-2005
The week ends on Saturday's
IN b1 through h1 there is a list of days starting at Sunday

What I need is to extract the Sunday amounts for the weekending date from
Column B based on the date in column a.

Ie. If Sunday is the heading what was the amount on sheet1 Column b that
was on Sunday for the weekending date.

Thanks In advance.




--
Carl & Linda Brehm
Lake Lafourche Bird House
Hebert, LA

Keets, Tiels, GN Lories, Quakers
Mitred Conures, TAG's, Bourkes
Lovebirds, Cherry Head Conures
Prince of Whales

Wholesale Cages to Breeders & Pet Stores

Formula Help
 

In sheet2 cell B2, use the sumif function:
=SUMIF(Sheet1!$A:$A,$A2+COLUMN()-8,Sheet1!$B:$B)

(If you really only need this for Sunday, replace +COLUMN()-8 with -6, but
I'm assuming you want to autofill this formula to columns 3 through 8 so you
can get each day's totals from the corresponding week.)


"Carl Brehm" wrote:

sheet1
Column A contains a list of dates. Formatted 18-Jan-2005
Column B a list of values Formatted as dollars

Sheet2
In column a Starting at a2 there is a list of weekending dates, Formatted 18-Jan-2005
The week ends on Saturday's
IN b1 through h1 there is a list of days starting at Sunday

What I need is to extract the Sunday amounts for the weekending date from
Column B based on the date in column a.

Ie. If Sunday is the heading what was the amount on sheet1 Column b that
was on Sunday for the weekending date.

Thanks In advance.




--
Carl & Linda Brehm
Lake Lafourche Bird House
Hebert, LA

Keets, Tiels, GN Lories, Quakers
Mitred Conures, TAG's, Bourkes
Lovebirds, Cherry Head Conures
Prince of Whales

Wholesale Cages to Breeders & Pet Stores