Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup or Hlookup does not work
Hi,
I need a simple formula... seems very diffucult to get In Sheet 1 I have employee names on horizontal line and a lot of numbers in vertical line. In Sheet2, i Have emloyee names on vertical line and in horisontal line i want to set up formula in sheet2 so that it calcualtes total number for each month for each name as per below sample: Sheet1 John Month days January 5 january 3 january 4 February 10 March 6 TOtal 28 Sheet 2 JOhn January February March 12 10 6 or at least John and 28 days total. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup or Hlookup does not work
Take a look SUMIF function in help menu or use PIVOT table
"Delya" wrote: Hi, I need a simple formula... seems very diffucult to get In Sheet 1 I have employee names on horizontal line and a lot of numbers in vertical line. In Sheet2, i Have emloyee names on vertical line and in horisontal line i want to set up formula in sheet2 so that it calcualtes total number for each month for each name as per below sample: Sheet1 John Month days January 5 january 3 january 4 February 10 March 6 TOtal 28 Sheet 2 JOhn January February March 12 10 6 or at least John and 28 days total. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup - HLookup | Excel Discussion (Misc queries) | |||
Vlookup & hlookup | Excel Worksheet Functions | |||
hlookup & vlookup together | Excel Discussion (Misc queries) | |||
vlookup & hlookup | Excel Worksheet Functions | |||
How do I use Vlookup or Hlookup? | Excel Discussion (Misc queries) |