SUMIF showing wrong values

[oppiz2]

Hello

I am trying to sum up some statistics for my friends
On my first sheet (GBM) I have on columns J K and L the following: Good Ba
Mediocre, while on column M the Name
Now on my 4th sheet I want to sum up the Good Bad and Mediocre for each one
Th
problem is I tried with SUMIF like this

=SUMIF('GBM'.M3:M65000;A2;'GBM'.J4:J65000

In A2 is the name of the subject. Instead of showing up 11 (calculated by pen
it shows 25. Same thing with the next: instead of showing 43 it shows 31
I would like to mention that I am also using openoffice.org spreadsheet on m
laptop and it would help having the formula in oo.o format also

Thanks.

 

[joeu2004]

problem is I tried with SUMIF like this:
=SUMIF('GBM'.M3:M65000;A2;'GBM'.J4:J65000)

In A2 is the name of the subject. Instead of showing up 11
(calculated by pen) it shows 25.

It is difficult to answer without seeing all of the data in order to
vet your expectations, and it appears that you did not copy and paste
the formula from the Formula Bar into your posting.

There seems to be obvious syntax errors: 'GBM'.M3:M65000 should be
'GBM'!M3:M65000 or GBM!M3:M65000. There is also a subtle error(?)
which may or may not be real/intended: M3:M65000 and J4:J65000 are
different size ranges.

I suggest that you upload an Excel file that demonstrates the problem
to a file-sharing web site and include a link to it in your next
posting. Some people have suggested the following:

MediaFire: http://www.mediafire.com/
FileFactory: http://www.filefactory.com/
FileSavr: http://www.filesavr.com/
FileDropper: http://www.filedropper.com/
RapidShare: http://www.rapidshare.com/

I have no experience with any of those web sites.

Also, for broader participation, you might want to post your inquiry
using the MS Answers Forums at
http://social.answers.microsoft.com/Forums/en-US/category/officeexcel.
It's not that I like that forum. It's just that MS has ceased to
support the Usenet newsgroups. Hence, participation here is limited
to the sites that share a common newsgroup mirror, which is no longer
centralized at MS.


----- original message -----

 

[Don Guillett Excel MVP]

It is difficult to answer without seeing all of the data in order to
vet your expectations, and it appears that you did not copy and paste
the formula from the Formula Bar into your posting.

There seems to be obvious syntax errors:  'GBM'.M3:M65000 should be
'GBM'!M3:M65000 or GBM!M3:M65000.  There is also a subtle error(?)
which may or may not be real/intended:  M3:M65000 and J4:J65000 are
different size ranges.

I suggest that you upload an Excel file that demonstrates the problem
to a file-sharing web site and include a link to it in your next
posting.  Some people have suggested the following:

    MediaFire:http://www.mediafire.com/
    FileFactory:http://www.filefactory.com/
    FileSavr:http://www.filesavr.com/
    FileDropper:http://www.filedropper.com/
    RapidShare:http://www.rapidshare.com/

I have no experience with any of those web sites.

Also, for broader participation, you might want to post your inquiry
using the MS Answers Forums athttp://social.answers.microsoft.com/Forums/en-US/category/officeexcel.
It's not that I like that forum.  It's just that MS has ceased to
support the Usenet newsgroups.  Hence, participation here is limited
to the sites that share a common newsgroup mirror, which is no longer
centralized at MS.

----- original message -----




- Show quoted text -

=SUMIF('GBM'.M3:M65000;A2;'GBM'.J4:J65000)
try to modify this to your needs. Use the same size range
=SUMIF(Sheet1!A2:A18,"a",Sheet1!B2:B18)
like
=SUMIF(GBM!M3:M65000;A2;GBM!!J3:J65000)