Lookup Problem

  • Thread starter Thread starter Dave Anderson
  • Start date Start date
D

Dave Anderson

Hi Guys

I am no expert on Excel but can find my way around and can
write some standard formulas but I am having some
difficulty with the following problem.

I have designed a spreadsheet to track and record my Poker
wins and LOSSES.

It has 4 Sheets, 1 for Ring Games, 1 for Single Table
Tournaments and 1 for Multi Table Tournaments and 1 sheet
for the bank. There each have different column headers in
them but are typical like:
Date Cash In Cash Out Profit

I then have a Bank Sheet which I is set out as below:
Date Ring Single Multi Cash In Cash Out Bank Roll

I have then used some Vlookup formulas to input the data
from the other sheets on to the bank sheet i have listed
the Ring one below:
=IF(ISERROR(VLOOKUP(A3,'Ring Games'!
A2:I100,9,0)),"",VLOOKUP(A3,'Ring Games'!A2:I100,9,0))

The problem I am having is that this only works if I have
only one session per type of game per day. Does anyone
know how I can either sum the total profit for say the
Ring Games on a certain date and then for the figure to be
automatically put into the Bank Sheet? Or any other way of
accomplishing this task?

TIA for your help.

Dave
 
Back
Top