I also forgot to mention that this project spans over several years and has
133 rows below the header line, which contains the dates.

Dates 31-mar-06 30-apr-06 31-may-06 30-jun-06 out to end dec
09
Task 1 5.5 3.4 1.2 2.6
Task 2 2.1 5.5 4.3 2.5
etc....down

Any way to make this easier?

Thanks............TC

"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