Check and copy most current non blank cell over the course of a month

[FERG NATION]

I enter the daily sales report for each sales person ... it is an updated total every day
i am trying to create a monthly tally for all the other information with the spreadsheet
but i need it to reference over the course of the whole month, final sales totals can be up to $50,0000 for the month
my daily sales tracker is one sheet and my monthly tracker is in another sheet all within the same work book
day 1 will be $2000 .... day 2 will be $3000 so on and so on .... so i can not do a sum function rather i need the formula
to look across the whole month and relay the most current number


SALES SHEET (separate from other data, sheet 1, book 1)

							SALES TO DATE
	1-Sep	2-Sep	3-Sep	4-Sep	5-Sep	6-Sep	7-Sep	8-Sep	9-Sep	10-Sep	11-Sep	12-Sep	13-Sep	14-Sep	15-Sep	16-Sep	17-Sep	18-Sep	19-Sep	20-Sep	21-Sep	22-Sep	23-Sep	24-Sep	25-Sep	26-Sep	27-Sep	28-Sep	29-Sep	30-Sep
DAVE	$ 1.00	$ 2.00	$ 3.00	$ 4.00	$ 5.00	$ 6.00	$ 7.00	$ 8.00	$ 9.00	$ 10.00	$ 11.00	$ 12.00	$ 13.00	$ 14.00	$ 15.00	$ 16.00	$ 17.00	$ 18.00	$ 19.00	$ 20.00	$ 21.00	$ 22.00	$ 23.00	$ 24.00	$ 25.00	$ 26.00	$ 27.00
JIM	$ 2.00	$ 2.00	$ 2.00	$ 2.00	$ 2.00	$ 3.00	$ 4.00	$ 5.00	$ 6.00	$ 7.00	$ 7.00	$ 7.00	$ 7.00	$ 7.00	$ 7.00	$ 7.00	$ 7.00	$ 7.00	$ 8.00	$ 9.00	$ 10.00	$ 11.00	$ 12.00	$ 13.00	$ 14.00	$ 15.00	$ 16.00
STEVE	$ 3.00	$ 4.00	$ 5.00	$ 6.00	$ 7.00	$ 8.00	$ 8.00	$ 8.00	$ 8.00	$ 8.00	$ 8.00	$ 8.00	$ 8.00	$ 8.00	$ 8.00	$ 9.00	$ 10.00	$ 11.00	$ 12.00	$ 13.00	$ 14.00	$ 15.00	$ 16.00	$ 17.00	$ 18.00	$ 19.00	$ 20.00
SUZY	$ 4.00	$ 4.00	$ 4.00	$ 4.00	$ 4.00	$ 4.00	$ 4.00	$ 4.00	$ 4.00	$ 4.00	$ 4.00	$ 4.00	$ 4.00	$ 4.00	$ 4.00	$ 4.00	$ 4.00	$ 4.00	$ 4.00	$ 4.00	$ 4.00	$ 5.00	$ 6.00	$ 7.00	$ 8.00	$ 9.00	$ 10.00

MONTHLY TOTAL SHEET (separate from other data, sheet 2, book 1)

	MONTHLY TOTAL
DAVE
JIM
STEVE
SUZY

last time i asked i was provided this formula

=LOOKUP(1E+100,INDEX($B$4:$AB$7,MATCH(A12,$A$4:$A$7,0),0))

tried to make adjustments but i keep getting n/a or error message

does anyone else have any ideas ... mind you the largest # will be $50,000

my chart is just an example

 

[Skovgaard]

I've read your post a couple of times now, but I don't think I understand correctly.
Why can't you use a normal SUM function, if you just want the total for the month, per salesperson?

/Skovgaard

 

[FERG NATION]

I've read your post a couple of times now, but I don't think I understand correctly.
Why can't you use a normal SUM function, if you just want the total for the month, per salesperson?

/Skovgaard

Because we dont add what was sold that day, thus creating a easy sum feature
every day we input what has been sold up that point
so i need the monthly sheet to reflect the update daily bc the sales are growing

 

[Skovgaard]

Because we dont add what was sold that day, thus creating a easy sum feature
every day we input what has been sold up that point
so i need the monthly sheet to reflect the update daily bc the sales are growing

I'm still uncertain.
Can you give an example? What should the "MONTHLY TOTAL" fx. be for DAVE on Sept 6?

/Skovgaard

 

[Fluff]

Duplicate to: Reference Current Non Blank Cell - Monthly Calendar

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.