Solved

Sum returning wrong value

Posted on 2014-10-13
3
79 Views
Last Modified: 2014-10-13
Can anyone tell me why cell aa in row 75 is returning a value of 11 instead of 12?
THS-Supplier-Partnership-Criteria.xlsx
0
Comment
Question by:robmarr700
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 4

Expert Comment

by:mbertl
ID: 40377149
Your document is linked to other external documents. Are they related and needed to your cell AA?
0
 

Author Comment

by:robmarr700
ID: 40377158
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
 
LVL 52

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 40377171
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

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question