I always want to get specific value as the sum of randomly generated values

For example I have sheet as shown below.

A | B | |

1 | =RANDBETWEEN(5,10)→ | 5 |

2 | =RANDBETWEEN(5,10)→ | 6 |

3 | =RANDBETWEEN(5,10)→ | 7 |

4 | =RANDBETWEEN(5,10)→ | 6 |

5 | =RANDBETWEEN(5,10)→ | 9 |

6 | =RANDBETWEEN(5,10)→ | 7 |

7 | =RANDBETWEEN(5,10)→ | 10 |

8 | =RANDBETWEEN(5,10)→ | 5 |

9 | =RANDBETWEEN(5,10)→ | 6 |

10 | =RANDBETWEEN(5,10)→ | 9 |

11 | =SUM(B1:B10)→ | 70 |

<tbody>

</tbody>

From the above sheet(table) I want to get specific value as the sum of value in Column B(B1:B10 contains =RANDBETWEEN(5,10))

If I want to get 92 as my sum of randomly generated value the excel should populate the random values in column B which gives sum of 92.

How do I do it?

Could someone help me please!