WUGNET, the Windows User Group Network
Your Complete Resource Center for "The Best" in Shareware, Computing Tips and Support, Windows Industry News... and much more!
Home Forums Shareware Windows Tips Hot Offers FREE Newsletters Arcade Contact Us About Partners
Search WUGNET: RSS Feeds RSS Feeds Advertise with WUGNET    |    Shareware eBooks
HomeHome FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

SUMIF function - has anyone begun receiving false results

 
   Home -> Office -> General Protection Fault Errors RSS
Next:  Excel 2003 and Excel 2007  
Author Message
-a

External


Since: Aug 14, 2008
Posts: 1



(Msg. 1) Posted: Thu Aug 14, 2008 5:53 pm
Post subject: SUMIF function - has anyone begun receiving false results
Archived from groups: microsoft>public>excel>crashesgpfs (more info?)

or odd circular reference errors in the past few (2,3) days using the SUMIF
function?

I thought I just had a crashed workbook. I copied the data (edit / copy,
edit / paste special / values) to a new workbook. Column A had values 1-5,
Column K had that results I wanted to sum. In cell M2, I had the value 1,
M3 = 2, M4=3, etc. through 5. In cell N2 the formula was: =SUMIF(A:K,M2,K:K)

There were no formulas in the workbook before this. I checked. I got a
circular reference error. If I added a "1" into one of the cells in column
M, it affected the result in N2. I was able to get rid of the circular
reference error by creating the SUMIF calc in a cell around N5, N6 or
something, but then it gave me wild values.

That was Wednesday, August 13th. I thought I had a crashed workbook. Pivot
table returned the results I needed just fine. I moved on.

Today, August 14th, I opened a workbook which had been built around the
SUMIF function two weeks ago. I loaded new data in and the results which
came back were absurd. I haven't been able to get it to run again.

We've reloaded Office 2003 three times today, including two system restores
- one to last week, one to two weeks ago. No good.

My other functions, such as COUNTIF, VLOOKUP, even an ERLang B calculator
work just fine. Pivot tables are summing just fine. It appears to be this
single function, SUMIF, which has stopped working. I went to a co-workers
desk. Their results were the same. Third person thought their SUMIF
function was working (something along the lines of : =
SUMIF(A1:Q13,"<50",A1:Q13) ) However, when we changed it to whole columns,
the results went nuts. Whole numbers were used & fractionals were returned.

Anyways, I was wondering if anyone else has seen such a thing happen in the
last little while.
Back to top
Login to vote
Display posts from previous:   
       Home -> Office -> General Protection Fault Errors All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Categories:
 Windows XP
 Windows Vista
 Windows Other
  Office
 Office Other
 Security
 WinRAR
  • Home |
  • Shareware |
  • Windows Tips |
  • Hot Offers |
  • FREE Newsletters |
  • Arcade |
  • Forums |
  • eBooks |
  • About WUGNET |
  • Partners |
  • Contact

  • WUGNET Privacy Policy |
  • Link to WUGNET