Adding total over two worksheets based on date values
 

I am working across two worksheets and need a formula to calculate the
following:
On worksheet 1, dates can be entered in cells (o30 to o40) inclusive.
In cells (p30 – p40) I wish to total the value of cells in worksheet 2
that occur along row 20
I only want them totaled if they are in a column that has a date
entered in row 3 above equal to or after the date entered in the
original cells on sheet 1 (o30-o40)
On worksheet 2 the dates are entered across the row (k3 – hd3)
Under these columns in worksheet 2 are the values in row 20 that I wish
to add.

Can someone assist. I just keep coming up with circular equations.
HELP.


--
dond
------------------------------------------------------------------------
dond's Profile: http://www.excelforum.com/member.php...o&userid=25477
View this thread: http://www.excelforum.com/showthread...hreadid=483060