Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |