Hello, I am looking for an excel formula that does the following:

We have a mark to reach, let's say MARK=12

In column A we have "random" amounts.

In column B, I want a formula that:

- Calculates the running amount in col A and

- If the running total has reached MARK, then display that running total, otherwise leave cell empty and THEN

- next cell repeats the process but ignoring the cells that were part of a running total previously displayed.

Example:

MARK = 12

Can you do this?

Thank you,

Celia

We have a mark to reach, let's say MARK=12

In column A we have "random" amounts.

In column B, I want a formula that:

- Calculates the running amount in col A and

- If the running total has reached MARK, then display that running total, otherwise leave cell empty and THEN

- next cell repeats the process but ignoring the cells that were part of a running total previously displayed.

Example:

MARK = 12

Col A | Col B |

7 | |

4 | |

5 | 16 |

1 | |

6 | |

5 | 12 |

6 | |

8 | 14 |

4 | |

3 | |

4 | |

8 | 19 |

... | and so on |

Thank you,

Celia

## Comment