See attachment.
I am trying to have excel only find the difference between the tach time in column A when an "X" is present in column B. For example, C10 should subtract A10 minus A9 since there is an "X" in B9. 1246.6 is not the difference between A10-A9. However the formula works for cell C9. It is searching for the next "X" from B9 and then subtracting A6 from A9. There are similar problems in cells C6, C11 and C14. Can anybody help me find a formula that would work for these calculations?
It would have been simpler if you had told us your EXPECTED results, rather than showing us a non working formula. Try this:
=IF(B2="X",SUM(A$2:A2),"") in B2, copied down.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thanks for helping. Unfortunately I do not want column A to continuously add up. I'll try to give a better explanation. If an "X" is present in column B than I want the number that corresponds to that in column A to be used in a SUM function with the next previous number in that column that has a "X" next to it in column B.
For example: Cell C6 should have the difference from A6-A5 since there is an "X" in cells B6 and B5. Cell C5 should have the difference from A5-A3 since there is an "X" in cells B5 and B3.
Hopefully this helps.
Still no manually calculated expected answers, but a better explanation:
=IFERROR(IF(B2="X",A2-LOOKUP(2,1/($B$1:B1="X"),$A$1:A1),""),0)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks