Countifs... excluding a row with specific text
Hello everyone,
thank you again for any help in advance
Trying to verify Column F, with the word "Default" in it and Column B has "0" or less in it, except for the rows with "DC" in them based on Column E.
If any cell in column B has a value other than the exclusion I want to return a false statement (Move On)
=IF(COUNTIFS(F2:F15,"Default",B2:B15,(B2:B15>0),E2:E15,"<>DC"),"Stop","Move On")
Test_with exclusions.xlsx
Hi,
you actually mean "larger than 0" right?
And i quite don't get why you tried to use Countifs, can you elaborate?
Anyway, try this:
Formula:
Please Login or Register to view this content.
John.
"I excel at jumping to conclusions"
Try this
Formula:Please Login or Register to view this content.
So you want 'Stop' only if there is at least one row with B<=0, F=Default and E<>DC?
Just add '=0' after your COUNTIFS in the IF statement:
Formula:Please Login or Register to view this content.
Does that do what you want?
Regards,
Aardigspook
I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
You don't need to give me rep if I helped, but a thank-you is nice.
If any of the other rows in B have a value I want to "Move On".
The placement of Balances and Zeros can be random, from another sheet.
Included forced results
Attachment 628239
Attempting to view the attachment in post #5 results in the following message: "Invalid Attachment specified. If you followed a valid link, please notify the administrator".
It might be better to upload another file as was done in post #1. It also might help if you would show multiple scenarios and manually fill in the expected values in column G.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks