Sum Function

Ray Whalley

New member
Joined
Dec 18, 2016
Messages
3
Reaction score
0
Points
0
The sum function will not calculate the sum of a range of cells containing numbers resulting from a range of IF functions. How can I correct this?? Ihave tried all the recommended soluyion to no avail.


Q1400 0 0 0 00
Q2511 1 1 1 51
Q3611 1 1 1 51
Q4711 1 1 1 51
Q5811 1 1 1 51
Q6911 1 1 1 51
25?
 

AliGW

Administrator
Joined
Nov 8, 2015
Messages
1,784
Reaction score
1
Points
38
Location
Ipswich, Suffolk, England
Excel Version(s)
MS 365 (Beta Insider Channel)
What is the formula you are using and where? If the final column, then there is a clue in the fact that the numbers are aligned left: thus suggests that they are text, not numbers.
 

Ray Whalley

New member
Joined
Dec 18, 2016
Messages
3
Reaction score
0
Points
0
I have already checked the cell and they are set on "general" .I have also set them as number with the same result.
The formula used to calculate the cells in question is =IF(AB46>=1,"1",IF(AB46<1,"0")) AB is the row with the 0.5.5.5.5.5.
 

AliGW

Administrator
Joined
Nov 8, 2015
Messages
1,784
Reaction score
1
Points
38
Location
Ipswich, Suffolk, England
Excel Version(s)
MS 365 (Beta Insider Channel)
See if this makes any difference:

=IF(AB46>=1,1,IF(AB46<1,0))

Notice no inverted commas around the numbers.
 

Ray Whalley

New member
Joined
Dec 18, 2016
Messages
3
Reaction score
0
Points
0
See if this makes any difference:

=IF(AB46>=1,1,IF(AB46<1,0))

Notice no inverted commas around the numbers.

This enables the Auto Sum to activate and I have achieved this previously by manually inserting a sum formula. Unfortuanately whilst the formulas say it is adding the relevant cell range containing figures 0.1.1.1.1.1 it is showing a total of 1 not 5.??
 

Pecoflyer

Admin Alumnus
Joined
Oct 13, 2011
Messages
1,766
Reaction score
0
Points
36
Location
Brussels Belgium
Excel Version(s)
2010 on Xubuntu - O365
Please post a small sample sheet (click Go advanced - Manage attachments). Thanks

BTW, please do not quote entire posts unnecessarily. They make the thread hard to follow.
Shorter version of Ali's formula =--(AB46>=1)
 
Last edited:
Top