Calculations across multiple columns based on non-blanks

Not applicable

Dear Experts,


Help please! Thank you in advance.


In the spreadsheet attached:

Row 1 notes different tram numbers

Column A notes distance travelled.

Columns B onwards has "1"s in rows noting where failures have occurred at corresponding distances, as per Column A.


I want to calculate the deltas only between the "1"s in each column. For example, in Column B there are four "1"s.  There should be 3 corresponding deltas.  Is there a way to do this, using arrays perhaps?


Many thanks.

1 Reply

For clarity, I should add the deltas must be of the distances in Column A.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
50 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
32 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
15 Replies
Dev channel update to 80.0.355.1 is live
josh_bodner in Discussions on
67 Replies