software

I have identified two cells in a table using vlookup amp; hlookup. I want to
sum the cells referred to by the lookups.

Hydro1guy

Just add the two lookups together

=VLOOKUP(Your_Vlookup) HLOOKUP(Your-Hlookup)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HISquot;hydro1guyquot; gt; wrote in message
...
gt;I have identified two cells in a table using vlookup amp; hlookup. I want to
gt; sum the cells referred to by the lookups.
THat works but I want to sum the range of cells between the two. I think I
may have to use address but cannot get it to work. How else can I identify
the actual cell address for my range?

quot;Nick Hodgequot; wrote:

gt; Hydro1guy
gt;
gt; Just add the two lookups together
gt;
gt; =VLOOKUP(Your_Vlookup) HLOOKUP(Your-Hlookup)
gt;
gt; --
gt; HTH
gt; Nick Hodge
gt; Microsoft MVP - Excel
gt; Southampton, England
gt; www.nickhodge.co.uk
gt; HIS
gt;
gt;
gt; quot;hydro1guyquot; gt; wrote in message
gt; ...
gt; gt;I have identified two cells in a table using vlookup amp; hlookup. I want to
gt; gt; sum the cells referred to by the lookups.
gt;
gt;
gt;

If you are summing a range your best bet is to use INDEX but you need to
indentify the 2 cells (no need for ADDRESS really) maybe using MATCH

--

Regards,

Peo Sjoblom

quot;hydro1guyquot; gt; wrote in message
...
gt; THat works but I want to sum the range of cells between the two. I think I
gt; may have to use address but cannot get it to work. How else can I identify
gt; the actual cell address for my range?
gt;
gt; quot;Nick Hodgequot; wrote:
gt;
gt; gt; Hydro1guy
gt; gt;
gt; gt; Just add the two lookups together
gt; gt;
gt; gt; =VLOOKUP(Your_Vlookup) HLOOKUP(Your-Hlookup)
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt; Nick Hodge
gt; gt; Microsoft MVP - Excel
gt; gt; Southampton, England
gt; gt; www.nickhodge.co.uk
gt; gt; HIS
gt; gt;
gt; gt;
gt; gt; quot;hydro1guyquot; gt; wrote in message
gt; gt; ...
gt; gt; gt;I have identified two cells in a table using vlookup amp; hlookup. I want
to
gt; gt; gt; sum the cells referred to by the lookups.
gt; gt;
gt; gt;
gt; gt;
123456
01-Jun313233343536
02-Jun789101112
03-Jun131415161718
04-Jun192021222324
05-Jun252627282930

this is a sample table. The top row is hour and the first colum is date. I
want to sum A range of cells determined by state date/hour and end date
hour.I can find the cells to start and finish the range by using Vamp;H lookup.
but cannot get the formula to sum them to work.

=sum((INDEX(B2:H6,VLOOKUP(B12,B2:H6,(B13 1)),HLOOK UP(B18,B2:H6,(B17 1)))))

help would be greatly appreciated

quot;Peo Sjoblomquot; wrote:

gt; If you are summing a range your best bet is to use INDEX but you need to
gt; indentify the 2 cells (no need for ADDRESS really) maybe using MATCH
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; quot;hydro1guyquot; gt; wrote in message
gt; ...
gt; gt; THat works but I want to sum the range of cells between the two. I think I
gt; gt; may have to use address but cannot get it to work. How else can I identify
gt; gt; the actual cell address for my range?
gt; gt;
gt; gt; quot;Nick Hodgequot; wrote:
gt; gt;
gt; gt; gt; Hydro1guy
gt; gt; gt;
gt; gt; gt; Just add the two lookups together
gt; gt; gt;
gt; gt; gt; =VLOOKUP(Your_Vlookup) HLOOKUP(Your-Hlookup)
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; HTH
gt; gt; gt; Nick Hodge
gt; gt; gt; Microsoft MVP - Excel
gt; gt; gt; Southampton, England
gt; gt; gt; www.nickhodge.co.uk
gt; gt; gt; HIS
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;hydro1guyquot; gt; wrote in message
gt; gt; gt; ...
gt; gt; gt; gt;I have identified two cells in a table using vlookup amp; hlookup. I want
gt; to
gt; gt; gt; gt; sum the cells referred to by the lookups.
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt;
gt;
gt;

OK, using your example, assume start date 3-June, end date 5-Jun
start hour 2 and end hour 5, using your example that would sum to 258,
with starts dat in B12, end in B13, start time in B17 and end in B18

=SUM(INDEX(B1:H6,MATCH(B12,B1:B6,0),MATCH(B17,B1:H 1,0)):INDEX(B1:H6,MATCH(B1
3,B1:B6,0),MATCH(B18,B1:H1,0)))

--

Regards,

Peo Sjoblom

quot;hydro1guyquot; gt; wrote in message
...
gt; 1 2 3 4 5 6
gt; 01-Jun 31 32 33 34 35 36
gt; 02-Jun 7 8 9 10 11 12
gt; 03-Jun 13 14 15 16 17 18
gt; 04-Jun 19 20 21 22 23 24
gt; 05-Jun 25 26 27 28 29 30
gt;
gt; this is a sample table. The top row is hour and the first colum is date. I
gt; want to sum A range of cells determined by state date/hour and end date
gt; hour.I can find the cells to start and finish the range by using Vamp;H
lookup.
gt; but cannot get the formula to sum them to work.
gt;
gt; =sum((INDEX(B2:H6,VLOOKUP(B12,B2:H6,(B13 1)),HLOOK UP(B18,B2:H6,(B17 1)))))
gt;
gt; help would be greatly appreciated
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt; gt; If you are summing a range your best bet is to use INDEX but you need
to
gt; gt; indentify the 2 cells (no need for ADDRESS really) maybe using MATCH
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Regards,
gt; gt;
gt; gt; Peo Sjoblom
gt; gt;
gt; gt; quot;hydro1guyquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; THat works but I want to sum the range of cells between the two. I
think I
gt; gt; gt; may have to use address but cannot get it to work. How else can I
identify
gt; gt; gt; the actual cell address for my range?
gt; gt; gt;
gt; gt; gt; quot;Nick Hodgequot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Hydro1guy
gt; gt; gt; gt;
gt; gt; gt; gt; Just add the two lookups together
gt; gt; gt; gt;
gt; gt; gt; gt; =VLOOKUP(Your_Vlookup) HLOOKUP(Your-Hlookup)
gt; gt; gt; gt;
gt; gt; gt; gt; --
gt; gt; gt; gt; HTH
gt; gt; gt; gt; Nick Hodge
gt; gt; gt; gt; Microsoft MVP - Excel
gt; gt; gt; gt; Southampton, England
gt; gt; gt; gt; www.nickhodge.co.uk
gt; gt; gt; gt; HIS
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; quot;hydro1guyquot; gt; wrote in message
gt; gt; gt; gt; ...
gt; gt; gt; gt; gt;I have identified two cells in a table using vlookup amp; hlookup. I
want
gt; gt; to
gt; gt; gt; gt; gt; sum the cells referred to by the lookups.
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;