Forum Discussion
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 correct value, but I need to add an additional condition to the formula - I want this to resolve when column F from the 'Test Set Test Cases' tab = "SCM". How do I add this condition to the below statement? Hopefully, I explained this correctly.
IF(ISBLANK(D7),"", COUNTIF ('Test Set Test Cases'!I:I,'Day by Day (2)'!$D7))
I'm struggling so I need another set of eyes or ideas. Your help is appreciated.
Thanks!
- 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
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"))
- Thank you very much. So glad there is a community like this!
- 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- Thank you very much - that did it!
