Excel SUM function is not working shows 0 but using Addition works

0 votes

In Excel, I'm at a loss (version 16.0, Office 365). I have several cells that are formatted as Number and have values greater than 0, but whenever I use the normal SUM() function on them, the result is always displayed as 0.0 rather than the actual sum. The amount is displayed appropriately when I use + in its place.

For example:

  • SUM(A1:A2) shows 0.0
  • A1 + A2 shows 43.2

I don't see any errors or little arrows on any of the cells.

Jan 5, 2023 in Others by Kithuzzz
• 38,010 points
521 views

1 answer to this question.

0 votes
The values in A1 and A2 are Text, which Excel is indicating (in a cryptic way).

SUM() ignores text values and produces a result of 0. Each value is first converted from text to a number using a direct addition formula before being added.

I hope this helps you.
answered Jan 5, 2023 by narikkadan
• 63,720 points

Related Questions In Others

0 votes
1 answer

Move_uploaded_file() function is not working

The file will be stored in a ...READ MORE

answered Feb 22, 2022 in Others by Aditya
• 7,680 points
2,950 views
0 votes
0 answers

why is react native video not working on android, but working on ios?

installed react video v. 5.2.0 but an error ...READ MORE

Sep 23, 2022 in Others by gaurav
• 23,260 points
1,148 views
0 votes
1 answer

Dynamic chart range using INDIRECT: That function is not valid (despite range highlighted)

Similar to Sean's fantastic response, mine also ...READ MORE

answered Dec 27, 2022 in Others by narikkadan
• 63,720 points
785 views
0 votes
1 answer

Excel number formatting thousands is not working

Follow these steps: 1- choose cells you want ...READ MORE

answered Feb 16, 2023 in Others by Kithuzzz
• 38,010 points
9,646 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,740 points
1,006 views
0 votes
1 answer

ImportError: openpyxl is required for loading excel format files

Forget the PsychoPy complications for the time ...READ MORE

answered Oct 3, 2018 in Python by Priyaj
• 58,090 points
919 views
0 votes
1 answer

In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

answered Oct 15, 2018 in RPA by Priyaj
• 58,090 points
4,205 views
0 votes
1 answer

Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,160 points
4,020 views
0 votes
1 answer

Excel MATCH function is not working on an array but works once directed to the matched value

According to the definition here: support.microsoft.com/en-us/office/… if you do ...READ MORE

answered Nov 17, 2022 in Others by narikkadan
• 63,720 points
770 views
0 votes
1 answer

Is there a way to test a formula result in excel and type it only once, all within one cell and not using a user defined function?

Use the Let function: =LET(Value,A1+B2+C4+G3+B4,IF(Value>10,"No",Value)) I hope this helps ...READ MORE

answered Jan 9, 2023 in Others by narikkadan
• 63,720 points
515 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP