Hi all,
Please can you help me? I need help with a formula. I need the formula to identify first cell with value, then skip / ignore blank cells, and find next cell (further down in spreadsheet) with a value, and perform calculation.
Screenshot (51).png
What is the calculation? Where does it go?
The calculation would be =SUM(B5-B4), and so on. It would continue to look up the next available value in order to do the calculation. Does this help at all?
It must determine the number of km's travelled between two dates - the calculation ignoring / skipping the blank cells, and finding the next cell with a value, in order to do the calculation for the km's travelled between the next two dates
Hello Angelique7 and Welcome to Excel Forum.
Please paste the following into cell F5 and copy down:Formula:
Please Login or Register to view this content.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Thank you so much for this formula JeteMc - it worked! Thank you so much for your help - I really appreciate it!
You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks