Hi
I am having data with text and numbers in a row please help me with a formula.
example
in row "A5" = text, "B5" = 10, "C5" = 10, "E5" = 15, "G5" = 10, etc.
i want the sum value in last row cell
Pls help me out
Hi
I am having data with text and numbers in a row please help me with a formula.
example
in row "A5" = text, "B5" = 10, "C5" = 10, "E5" = 15, "G5" = 10, etc.
i want the sum value in last row cell
Pls help me out
you can simply use =SUM(range) function. Sum function can ignore text and add only numbers.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Please attach a sample workbook showing the desired results.
You can attach a sample workbook by clicking on "Go Advanced" button below the post and then selecting the "Paper Clip" icon from the tools above.
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
Did you try =SUM(A5:G5)?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks