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?
 
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.
 
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.
 
See if this makes any difference:

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

Notice no inverted commas around the numbers.
 
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.??
 
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:
Back
Top