Sum returning wrong value

Can anyone tell me why cell aa in row 75 is returning a value of 11 instead of 12?
THS-Supplier-Partnership-Criteria.xlsx
robmarr700Asked:
Who is Participating?
 
Rgonzo1971Connect With a Mentor Commented:
Hi,

in Col W change your formula to

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

instead of your old formula which have text "1"

Regards
0
 
Manfred BertlManagerCommented:
Your document is linked to other external documents. Are they related and needed to your cell AA?
0
 
robmarr700Author Commented:
Some of the values have been pulled using Vlookups from other excel documents. These values are needed. Ideally I don't want to paste as values as the values on the external sheets may change.....
0
All Courses

From novice to tech pro — start learning today.