Biff,

This doesn't work. I've tried it every which way but loose and can't get it
to adapt.

My dates are in Row 47 from L47 to CQ47, including quarters. The data I'm
trying to look up and sum is located 7 rows below in Row 53. I need to sum
the numbers between L53 (31-Dec-04) and BO53 (31-Mar-08) and divide the total
by 2.

I will be entering the date range in CU46 (31-Dec-04) and CV56 (31-Mar-08).
This range is variable so the formula must read the start date in CU46 and
the end date in CV56.

I will be doing this function for all 133 rows below Row 47.

In short, look up the start date and the end date in Row 47. Go down
vertically 7 rows and find the numbers associated with the start and end date
respectively. Sum those numbers and divide by 2.

Thanks again......Tommy

"Biff" wrote:

I forgot something!

Assume the 12 EOM dates are in the range A1:L1

AND the numbers are in the range A2:L2.

Biff

"Biff" wrote in message
...
Hi!

One way:

You need 2 cells to hold the span that you're interested in.

Assume the 12 EOM dates are in the range A1:L1

N1 = header = From
O1 = header = To

N2 = Mar
O2 = May

=SUMIF(A1:L1,"="&DATEVALUE(N2&"
"&2006),A2:L2)-SUMIF(A1:L1,""&DATEVALUE(O2&" "&2006)+32,A2:L2)

Format the formula cell as GENERAL

Biff

"TomCat" wrote in message
...
I have a chart of numbers pertaining to progress of a project by month.
The
end of month dates are in a row across the top, the progress % are in
corresponding rows and columns below:

31-mar-06 30-apr-06 31-may-06 30-jun-06
5.5 3.4 1.2 2.6

I'm trying to do a SUM of HLOOKUP values to get a total progress for a
given
month. For example, I need to see the total progress for end of May from
end
of March: SUM(HLOOKUP(5.5) to HLOOKUP(1.2))=5.5+3.4+1.2 in a cell at
the
end of the row. How can I do this? Do I need to use another function?
Thanx............TomCat