Using VLOOKUP or HLOOKUP to sum ROWS
 

Assumptions:
In B1: Jul-08 (a 1st-of-month real date)
In D2: Jul-08 (the same 1st-of-month real date)
(you have merged D2:E2. so the only value is the one in D2.
as a general rule, don't use merged cells)

In F5: =SUM(OFFSET(A5,,MATCH($B$1,B$2:E$2,0),,2))
Copy F2 down
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,700 Files:356 Subscribers:53
xdemechanik
---
"Browny" wrote:
I wish to sum the values in row 5 (column D & E, which are merged), that
compares to the date in B1
in othwers words 'Jul-08 (B1) looks up 'Jul-08 in cloumns D & E and sums the
values = 10 + 10 and places result in column F
A B C D E F
1 AS AT Jul-08
2 Jun-08 Jul-08
3 Mon Fri Fri Sat
5 10 10 10 10 20


--
Browny