jlcannon
asked on
Non working formula in Excel
Can anyone tell me what i need to do to make this formula work. The problem is the <>"DM" becuase if i take out the <> it works fine but i need everything not equal to DM in that range.
=SUMIFS('Business Objects_Data'!P120:P148,'B usiness Objects_Data'!Q120:Q148,<> "DM",'Busi ness Objects_Data'!F120:F148,"0 1")
=SUMIFS('Business Objects_Data'!P120:P148,'B
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This solution worked perfectly. thank you!
@barryhoudini I tried putting it all in the same quates and it still came up with an error but once i put "<>" and "DM" in seperate quotes it worked. Thank you for the help.
@barryhoudini I tried putting it all in the same quates and it still came up with an error but once i put "<>" and "DM" in seperate quotes it worked. Thank you for the help.
Are you sure? If I use Netty's suggested solution, e.g. with simplified SUMIF
=SUMIF(A:A,"<>"DM"",B:B)
Then I get an error message, whereas if I use my suggestion
=SUMIF(A:A,"<>DM",B:B)
that works fine
It's possible to put them both in quotes and concatenate like this
=SUMIF(A:A,"<>"&"DM",B:B)
but that isn't really necessary
regards, barry
=SUMIF(A:A,"<>"DM"",B:B)
Then I get an error message, whereas if I use my suggestion
=SUMIF(A:A,"<>DM",B:B)
that works fine
It's possible to put them both in quotes and concatenate like this
=SUMIF(A:A,"<>"&"DM",B:B)
but that isn't really necessary
regards, barry
=SUMIFS('Business Objects_Data'!P120:P148,'B
regards, barry