Hi,
I am trying to create a tracker for cash variances among my staff. I have a worksheet for each day of the month and a Variance worksheet that will hold all the compiled information. Attached is an short version of my workbook. The yellow cells are the cells that will contain the information I need.
In Cells G26:G28 will be the names of the cashiers. In cells H26:h28 will the a dollar amount and in cells I26:I28 will be how many times it occurred. My If statment looks like the following : =IF('1'!G26="Billy",'1'!H26*'1'!I26,0). How ever if Billys name is put into G27, then I'd like H27 to multiply by I27. Since I have at least 30 worksheets and approximately 15 staff members writing three different If statments for each will become extremely exhausting.
Is there a better way to do this ?
Thanks for your Help
Example to post.xls
Bookmarks