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:
The sheet is attached.
Please Login or Register to view this content.
I would really appreciate some help on this, thanks.
Sud
Try this in the yellow cell:
=COUNTA(FILTER('ITP Reg'!$G$5:$G$494,('ITP Reg'!$G$5:$G$494='ITP Summary by package'!$A60),"No results"))
... or just use the rows formula!!
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Maybe I'm missing something, but why not a straightforward COUNTIFS()
=COUNTIFS('ITP Reg'!G:G,'ITP Summary by package'!A60)
or maybe
=LET(a,COUNTIFS('ITP Reg'!G:G,'ITP Summary by package'!A60),IF(a=0,"No Results",a))
Last edited by Richard Buttrey; 07-17-2022 at 06:07 AM.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks