Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Misc
sumif detects wrong rows
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="T. Valko, post: 3175201"] =sumif($a:$a,"<<Other>>BaseCost",as:as) What's happening is the criteria is being evaluated as: greater than "<Other>>BaseCost" And the formula blank evaluates to be greater than "<Other>>BaseCost". Little known about SUMIF and COUNTIF is that they can determine < and > on TEXT. Consider this: x...5 y...2 =SUMIF(A1:A2.">x",B1:B2) Result = 2 x...5 a...2 =SUMIF(A1:A2.">x",B1:B2) Result = 0 So, you should probably use SUMPRODUCT. [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Misc
sumif detects wrong rows
Top
