Forum Discussion

RmLaMont's avatar
RmLaMont
Copper Contributor
Apr 10, 2023
Solved

Formula Help

I have a formula working and returning the correct value. What I need now is to add 1 more condition based on a value from column F from the 'Test Set Test Cases' tab.    The below resolves to a co...
Formulas and Functions
  • mtarler's avatar
    mtarler
    Apr 10, 2023
    sounds like you want:
    IF(ISBLANK(D7),"", COUNTIFS ('Test Set Test Cases'!I:I,'Day by Day (2)'!$D7, 'Test Set Test Cases'!F:F, "SCM" ))
    notice I changed from COUNTIF to COUNTIFS
HansVogelaar's avatar
HansVogelaar
MVP
Apr 10, 2023

RmLaMont 

You can use COUNTIFS instead of COUNTIF:

 

=IF(ISBLANK(D7), "", COUNTIFS('Test Set Test Cases'!I:I, 'Day by Day (2)'!$D7, 'Test Set Test Cases'!F:F, "SCM"))

RmLaMont's avatar
RmLaMont
Copper Contributor
Apr 10, 2023
Thank you very much. So glad there is a community like this!