Formula Help

C

Carl Brehm

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
 
G

Guest

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.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

.cells help 3
Range("Weekending").Cells.Columns.Count 4
Sumif Help needed 3
Function to convert string 13
sum (column 2 of namedrange) 4
Sumif Function Help 1
Error 1004 help 4
Help with summing 3

Top