UserNewQuestions ✭

Overview

Overview

Roles	Member
Badges	1

About Me

About Me

Not much happening here, yet.

Analytics

9

Posts

19

Visits

6

Points

Feb 13, 2024

Join Date

Feb 21, 2024

Last Active

Reactions

• Awesome 1

  1

• Discussions3
• Comments6

Discussions

• SUMIFS and CONTAINS with column criteria, Within CONTAINS can a "Not Equal To" operator be used.

  Hello all!!! I am trying to modify a working equation "=SUMIFS([Task Ratio]:[Task Ratio], NeedsText:NeedsText, CONTAINS("Quick Win", @cell), AssignedText:AssignedText, CONTAINS("First.Last1", @cell)) …

  

  Answered

  Formulas and Functions

  124

  Feb 15, 2024

  3

• SUMIFS & CONTAINS using multiple columns and criteria.

  Hello All! I am trying to sum cell numbers if conditions (per row) meet the acceptance criteria in two other columns. One of the criteria columns contains multiple contacts. I have tried using MS Copi…

  

  Answered ✓

  Formulas and Functions

  1319

  Feb 15, 2024

  2

• Use of COUNTIF and CONTAINS to search 2 columns for a specific condition

  Hello all!!!; I am trying to search in rows across 2 columns for a specific condition that I want to count the total number of. These columns are in the same sheet (See attached). My formula that retu…

  

  Answered ✓

  Countif

  Formulas and Functions

  727

  Feb 13, 2024

  6