Text into a cell

[pjinacio]

Hi!

I'm burning my brain how to get a solution for this.

I have a table with this data

A1 B1 C1
1 REF. DESCRIÇÃO Quantidade
2 mp ccc Carbonato de Cálcio 5.000
3 mp mlh Milho 4.500
4 mp st10 Premix starter ST 10 2.500
5 mp pst50 Premix pré-starter PST50 1.500
6 TOTAL 13.500

and I want to have as a result the following in a new cell " Matérias primas total -> 13.500"

the information in the table sometimes can be like this
A1 B1 C1
1 REF. DESCRIÇÃO Quantidade
2 NC Credit note
3
4
5
6 TOTAL

It can be also like this
A1 B1 C1
1 REF. DESCRIÇÃO Quantidade
2 PABT PC ABT 5000
3 REABT RE ABT 500
4 RABT R ABT 7000
5
6 TOTAL 12.500

For this situation I was able to get all this information about "descrição" and quantity in the same cell as a summary from the input in the table.

Also when I have "credit note" in the DESCRIÇÃO (B1) I'm able to put this information to appear.

My big question is how can I make this " Matérias primas total -> 13.500" as my result when I have this kind of information in the table.

[MarvinP]

You need to put a formula in a cell "=Sum(c2:c20)"
The C2:C20 is the range which captures all the numbers you want to add together.
If you want in the same cell words, you put in your formula something like:
="These are words " & Sum(c2:c20)

[Charlie_Howell]

it looks like you have text mixed with your numbers so you have to separate them with a fomula to clean it up.

[Charlie_Howell]

You can also try these examples too.

[pjinacio]

Hi again.

I send attached the file where I'm working so that you can see my problem, because I was not very clear in my explanation.

I will try to be more clear now and I think it will be easier for you to help me

I have this excel file 80 (F1 until F80) sheets where I input the information from individual invoices that I translate from Bulgarian to Portuguese.

I also have a sheet called "Tipos de produto" where I have all the products that I use to in the sheets (F1 to F80)

I another sheet where I have the information from the clients "Clientes". Here I input the information from all the clients that I work with

My problem is in the sheet "Lista Facturas a receber" where I want to collect the types of products that I use in the invoice into a summary cells.

I send In attached a pdf file with different models.

using the product "NC - nota de crédito" - This code works without any problem

using the product "VQA - venda equipamentos agrícolas" - This code works without any problem

using the product "PABT - Porcos p/ abate" or this "RABT - Reprodutoras p/ abate" or "REABT - Reprodutores p/ abate" - This code works without any problem and I'm able to collect the information from the different cells into only one summary cell as you can see in the pdf file

when I use the codes starting with "MP" I have the problem becuase I don't need to collect the information individual from each one. I want to have only this information as a final result "Vendas de matérias primas -> xxxxx Tons." So I want to sum the value and to identify the lines where I use the products starting with "MP".

I hope that know is more clear my question.

[Charlie_Howell]

i wrote a small "if(or(" statement and entered it into your workbook I hope this works.