Hello, Please look at this an bare it in mind as i try to explain my problem.
http://i252.photobucket.com/albums/h...Untitled-3.png
I need my "profit since last" to display the profit since the previous data entry.
The table currently works, but only so long as data is enetred for each an every hour.
If a time slot is missing, i want it to look to the hour previous to it an use that data instead.
any ideas?
can you attach the spreadsheet , also can you put what you would like to see as the result
maybe an if()
so if the cash column is zero - than make the cell blank
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Thanks for the reply.
Iv'e edited the spreadsheet now, it works fine but it's not what i was trying to achieve. If possible, i'd like the current profit to be the profit since the previous. There might be a gap in rows of 1, or 10, depending what time i get on to check it, so it needs to look, and if the cell is empty, use the one above it etc.
I'm sorry but i have barley any knowledge of spreadsheet beyond the basic stuff so that's all i can say.
In essence i want it to show my my profit made per hour, and a total of the days profit below!
If you can do it ill love you forever if not ill make do with this....
Thanks
thanks, I'm not sure I'm understanding
can you mention which cells we are looking at , and where you want results and what they should
is it the cells D36 and D37 - so they always pick up the amounts
I dont know how you get D36
I assume D37 is the max () of column F , as each hour the total increases
D36 an D37 are manually entered from what i start with, an what i end with, its just an easier way to work out the days profit an then move it to the right an keep track of it all..
H11 to H34 is what id like to be different.
Instead of them taking the total value, and deduction the starting amount to show the profit, id like them to also factor into the formula the profit from the previous hour.
So if i have 400k profit, and over the next hour my total profit rises to 460k, i want my profit column to display 60k, not 460k.
I was able to do that, the problem i had is if i dont enter data on every row, how do i make it do that if between say 2am and 4pm there is no data? I want the 5pm row to factor in the 1am data etc...
It's confusing to try an explain but i hope you get it from that.
Thanks
so in cell H30 , in your example should be
£354,375
Yep thats right
does this work at all
=IF(F11="","",MAX($F$11:F11)-$D$36-SUM($H10:H$10))
put in H11 and copy down
I dont believe so, bare in mind my values can go down as well as up btw!
But the value in F11 is always the latest to total, so we don't really need to use MAX at all
=IF(F11="","",F11-$D$36-SUM($H10:H$10))
so all we need to do as add up all the previous values H to get the difference
That seems to be working! any idea how i can make the days ending total display the most recent figure? Thansk a lot!
Scrap that i no longer need it, i just do a sum of all the profits :D
your welcome
if my assistance has helped, and only if you wish to , there is a reputation icon * on the left hand side - you can add to my reputation here
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks