Hi everyone. I need help to built a formula to sum specific values in a cell, if this is possible. Let me explain this better.
In a cell, let's say A1, I have the following narratives:
01.08.2023 / 2 issues caused by bad weather, 02.08.2023 / 2 issues caused by drivers' fault, 03.08.2023 / 8 issues caused by bad weather, 04.08.2023 / 4 issues caused by drivers' fault. Is it possible to sum in different cells the issues caused by bad weather and the issues cause by driver's fault? I'm using excel 365. Thank you so much for any help provided.
In a cell, let's say A1, I have the following narratives:
01.08.2023 / 2 issues caused by bad weather, 02.08.2023 / 2 issues caused by drivers' fault, 03.08.2023 / 8 issues caused by bad weather, 04.08.2023 / 4 issues caused by drivers' fault. Is it possible to sum in different cells the issues caused by bad weather and the issues cause by driver's fault? I'm using excel 365. Thank you so much for any help provided.