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
|