Using VLOOKUP or HLOOKUP to sum ROWS

[Browny]

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

 

[Max]

In F5: =SUM(OFFSET(A5,,MATCH($B$1,B$2:E$2,0),,2))
Note that the "2" in the expression is a hard coded figure used (it is the
width param in the OFFSET), since there's really no way to "know" the extent
of your merge of D2 into x number of cells.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,700 Files:356 Subscribers:53
xdemechanik
---