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

Status
Not open for further replies.

FERG NATION

New Member
Joined
Apr 14, 2022
Messages
12
Office Version
  1. 365
  2. 2021
Platform
  1. Windows
  2. Web
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-Sep2-Sep3-Sep4-Sep5-Sep6-Sep7-Sep8-Sep9-Sep10-Sep11-Sep12-Sep13-Sep14-Sep15-Sep16-Sep17-Sep18-Sep19-Sep20-Sep21-Sep22-Sep23-Sep24-Sep25-Sep26-Sep27-Sep28-Sep29-Sep30-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
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
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
 
Upvote 0
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
 
Upvote 0
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
 
Upvote 0
Status
Not open for further replies.

Forum statistics

Threads
1,213,490
Messages
6,113,956
Members
448,535
Latest member
alrossman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top