Hi,
I have a register with count(filter) formula to calculate the number of filtered rows in another sheet. However, the formula didnot yield the correct results. As, for example in the sheet attached, the yellow highlighted number in the first sheet should be 52 and not 49, and I could not figure out where the error is in the formula. The formula is as below:
=COUNT(FILTER('ITP Reg'!$A$5:$L$494,('ITP Reg'!$G$5:$G$494='ITP Summary by package'!$A60),"No results"))
The sheet is attached.
I would really appreciate some help on this, thanks.
Sud
Bookmarks