Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Deeps
 
Posts: n/a
Default VLOOKUP

I need help on this one.

The first sheet on my excel, contains data for different dates as shown
below: (11 columns)
Date Trans subtype PG SSN, Time Taken, No of transc, verifyier,
time taken
19-jun Lu Rollover 525 999 2 4
SM 2
19-jun Lu Rollover 525 999 2 4
SM 2
20-jun Lu Rollover 525 999 2 4
SM 2
20-jun Lu Rollover 525 999 2 4
SM 2

Now, on my second sheet, I want a formula which will give me the total no of
tranc(transactions) done on 19-june & the total time taken to do those
transactions.?

I was trying the VLookup formula on my second sheet in this way.
say on b1 I enter the date 19-june, and below that under the heading of
TOTAL NO of Transactions, I enter this formula: =VLOOKUP(B1,DJ!A1:G19,7,0)
where DJ is the name of my first sheet & 7 is he seventh column from left.

1) How do I get the total no of transactions done on 19-june and the total
time taken to do them on that day? When I enter the date on b1 cell it should
sum up the total for that day.

2) How do I also get the total Time Taken to Verify those transactions done
on 19-june?

Please advise
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
VLOOKUP Problem Ian Excel Discussion (Misc queries) 3 April 6th 06 06:47 PM
Using single cell reference as table array argument in Vlookup CornNiblet Excel Worksheet Functions 3 September 22nd 05 09:15 AM
VLOOKUP Limitations chris_manning Excel Worksheet Functions 2 August 9th 05 06:23 PM
vlookup data hidden within worksheet Excel Worksheet Functions 0 January 26th 05 12:09 PM
Vlookup info being used without vlookup table attached? Excel Worksheet Functions 0 January 25th 05 10:43 AM


All times are GMT +1. The time now is 12:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"