Hello All,
i am working on a excel sheet for my company and i am stuck at a certain point. I hope you guys could give me some advise on how to continue with my work.
Below I inserted the cells what i want to use for counting,
As you see in the left cells there are different text values. I want in a different cell he checks these left cells and if he found "text2" then he sum the values from cell exactly right next to it, So the end value will be 1600.
Please let me know if you have some idea,
<12>1234text 100,00
<20>2345text2 200,00
<20>2345text2 200,00
<20>2345text2 200,00
<20>2345text2 200,00
<12>1234text 100,00
<20>2345text2 200,00
<20>2345text2 200,00
<20>2345text2 200,00
<12>1234text 100,00
<20>2345text2 200,00
Bookmarks