Posted to microsoft.public.excel.misc

Browny

external usenet poster

Posts: 40

Using VLOOKUP or HLOOKUP to sum ROWS

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using VLOOKUP or HLOOKUP to sum ROWS	Max	Excel Discussion (Misc queries)	0	August 4th 08 04:35 AM
vlookup and hlookup	Lori	Excel Worksheet Functions	1	April 17th 07 03:10 PM
VLOOKUP , HLOOKUP	bijan	Excel Discussion (Misc queries)	4	January 7th 07 08:04 PM
VLookup & HLookup	[email protected]	Excel Discussion (Misc queries)	2	October 3rd 05 03:36 PM
Vlookup and Hlookup	Phlogiston2312	Excel Worksheet Functions	2	April 20th 05 05:09 PM

All times are GMT +1. The time now is 06:35 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us