Forum Discussion
Ayuda en EXCEL. I need help with excel.
ES. Quiero sumar el contenido de una columna cuyas celdas contienen el resultado/producto de una fórmula en forma de número. Si puedo poner la función autosuma pero no me arroja ningún número.
Gracias por su ayuda.
EN. I want to sum the content of a column in cells contain the result / product of a formula in number format. I can put the autosum function but it doesn't return any number. Thanks for your help.
4 Replies
SUM() ignores all texts, please check you have numbers, not texts. Which format did you apply doesn't matter. As variant you may check if A1 is text or not by =ISTEXT(A1) in any empty cell.
Please read this infos
Welcome to your Excel discussion space! - Microsoft Tech Community
With your permission, if I can recommend you, add a file (without sensitive data) to your project.
Explain your plans in relation to this file. So you can get a solution that is tailored to your needs much faster.
At the same time, it is much easier for someone who wants to help to understand the subject.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
ES. Gracias ya lo he resuelto, ahora: ¿Dónde lo puedo eliminar o marcar como encontrado?
EN. Thanks, I have solved it, now: Where can I delete or mark it as found?NikolinoDE
- I am glad you were able to solve your problem.
Have fun with Excel.
If in the end, one of the posts helped as a solution, mark this post with the correct answer or give likes so that other members can benefit from it later.
You don't have to do anything, you could do it ...
I would be happy to see you continue with new questions.
Ask as much and as often as you like.
My motto: There are no stupid questions, there are only stupid answers that you could get.
Your Welcomme
Nikolino
