Max and Biff, thanks for your help. Biff, I could never get yours to work.
Max, yours worked great except in a couple of lines where it's off by .53.
That will be my mission for the morning.

Max: I need an explanation of what you did. Can you walk me thru the
formula? I saw some double commas there? I'm not familiar with that syntax.
If you could be so kind as to step me thru it!

Thanks VERY MUCH, Y'ALL!...........TomCat!

"Max" wrote:

Re my response in the other branch ..

Try this adaptation in say, CT53:
=IF(OR($CU$46="",$CV$46=""),"",SUM(OFFSET(K53,,MAT CH($CU$46,$L$47:$CQ$47,0),,MATCH($CV$46,$L$47:$CQ$ 47,0)-MATCH($CU$46,$L$47:$CQ$47,0)+1))/2)
Copy CT53 down

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"TomCat" wrote:
...
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.