Forum Discussion

ragomes1972

Copper Contributor

Apr 13, 2021

Not able to fix Zero-length String in Formula

Hi, I'm using a formula that is trying to calculate the total number of items (or tickets) using COUNTIFS from a table based on 3 different criteria. However, the criteria for column W which is look...

Excel-formula-help2.xlsx18 KB

Formulas and Functions

JMB17

Bronze Contributor

Apr 14, 2021

As an alternative, perhaps try:
=SUMPRODUCT(--(INDIRECT("'JQL - Sprint "& A2 & "'!B:B")="Bug"),--(INDIRECT("'JQL - Sprint "& A2 & "'!U:U")=""),--(INDIRECT("'JQL - Sprint "& A2 & "'!W:W")<>""))