SJM1609 · SJM Data · ✭✭✭

Overview

Overview

Roles	Member
Badges	11

About Me

About Me

Title	SJM Data
Area of Expertise	Data Analysis

Analytics

11

Posts

76

Visits

253

Points

Nov 21, 2023

Join Date

Mar 6, 2024

Last Active

Reactions

No reactions yet.

• Discussions2
• Comments9

Discussions

• COUNTIF cells match in different sheets

  I am struggling to get a count if cells match when referencing different sheets. I am working on "Sheet 0" and want to check how many cells in "Sheet 1" match cells in "Sheet 2" for one column. Here i…

  

  Answered

  Formulas and Functions

  337

  Dec 15, 2023

  5

• How do I Check/Uncheck Parent if at least 1 Child is checked?

  I have been using this formula: =IF(COUNTIFS(CHILDREN(), <>0), 1, 0) but if more that one child is checked in the column it comes up with #INVALID DATA TYPE . How can i fix this. The requirement is at…

  

  Answered ✓

  Formulas and Functions

  192

  Nov 21, 2023

  4