CODEWITHSUNDEEP
excelexcel-formula
Samantha Jones
Samantha Jones

Reputation: 21

How do you add values in excel column?

My excel column is not adding up at all and I am using O365. Any ideas?

Excel not autosuming

Upvotes: 0

Views: 147

Answers (2)

jlear
jlear

Reputation: 180

Adding text to number cells makes your life much more difficult. You may want to consider putting only numbers in the cells and formatting the numbers to look like they have the text units in them. Check out this solution for instructions.

Upvotes: 0

Gary's Student
Gary's Student

Reputation: 96773

Consider the array formula:

=SUM(--SUBSTITUTE(D4:D7,"GB",""))

or (depending on your Locale):

=SUM(--SUBSTITUTE(D4:D7;"GB";""))

enter image description here

(some versions of Excel may not require an array-formula.)

EDIT#1:

Array formulas must be entered with Ctrl + Shift + Enter rather than just the Enter key. If this is done correctly, the formula will appear with curly braces around it in the Formula Bar.

Upvotes: 1

Related Questions