Sorry I couldn't think of a more specific thread title. I think I need a remedial explanation about SUMIF because I can't fathom For SUMIF gurus:
A1="X+10*10"
B1
Note, B1 now shows
+10*10
However, use my A1 and B1; don't just type +10*10 in B1.
Type a 1 in A2. Hit the 1 key and enter key.
c
gives 0
A2=1
(type =1 in A2)
C1=SUMIF(A2:A2,">0",B1:B1)
gives 1
Why?
By the way, to save yourself a couple of typing strokes
C1=SUMIF(A2,">0",B1)
gives the same as
C1=SUMIF(A2:A2,">0",B1:B1)
Chip, if you can read this, you're STILL making the world a better place with your immeasurably valuable gifts. Every week, you continue to help me (and untold numbers of others) tremendously. Practically no alternative outlets can match your effectiveness, even over the vast number of topics you demystify and empower usage of. You were, and still are, amazing.
I think you are missing something regarding the formula in B1 from your post here - http://www.excelforum.com/excel-gene...on-parser.html
In any case, I am getting 0s for both. Are you able to post a sample file with those things happening?
I simply vegged out when copy/pasting, sorry! Try it with
B1=mid(a1,2,99)
and indicate which version you tried (I'm 2003 whenever possible!)
Thanks
Yes, versions.
Excel 2003 SP3: Result 0 for both =1 and 1
Excel 2007 SP3: Result 0 for both =1 and 1
Excel 2010 SP2: Result 0 for both =1 and 1
Excel 2007 MSO15.0.4745.1000: Result 0 for both =1 and 1
All 32-bit
Thank you for your patience. Currently I'm getting the expected 0 result each time too. I'm going to try it once again tonight on the machine this was observed on; but for now I'm going to assume it was a corrupt file. Or further user errorFishy, because two versions of Excel showed the odd result.
I appreciate your steady confirmation of the correct outcome.
sumifhuh.xls Hmm. I built this from scratch, just 4 simple cells. In 97 and 03 I see the sumif result as 1. If you type a 1 in A2 and hit enter, the sumif becomes 0. At least that is what happens here.
Now only 97 fails consistently. Perhaps a bug in 97 and I won't be surprised if no one can even test that (I use it often for its small footprint and it's quick). I can't make it consistently happen in 03 (as soon as I save it and reopen, including the attachment above, it gives 0 as it should).
Oh well, "one of those things." Thanks for your and anyone's valuable time checking this but I don't think any epiphanies are available!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks