Share via

sumifs function - combine a cell reference with boolean operator in criteria?

Anonymous
2019-03-02T14:09:48+00:00

In my table, I have a string value in a cell that I want to exclude, so my formula looks like sumifs(sum_range, ...other ranges and criteria..., criteria_range, "<>[@cell reference]"). I think the criteria is being evaluated to find "[@cell reference]" as a text string, not as a relative reference. In the help examples, the criteria is "<> apples", which would exclude all rows having a value of "apples" in the criteria range.

Is there another way to do what I want?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2019-03-02T14:48:03+00:00

Thanks, Jeovany. I just tried something I haven't seen documented and it works. For my criterion, I surrounded the cell reference with a not() operator and voila! So, I have sumifs(…,...,...,criteria range, not(reference)). I hope that's clear to anybody reading this.

Cheers,

Dave

Was this answer helpful?

0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-03-02T14:22:13+00:00

    Hi Dave

    I would like to help you but I'm don't quite understand your point.

    Could you please post more information or details of your goal.

    A screenshot of your data will help, Also post the results expected.

    Remove any confidential / sensitive data.

    Do let me know if you require any further help on this. Will be glad to help you.

    Thanks

    Regards

    Jeovany CV

    Was this answer helpful?

    0 comments