Hi guys
I have a countif on my 2nd tab (see highlighted cells in yellow) it is not counting text from the first tab and as the first tab has drop downs, i have even checked/inserrted spaces after my text, but don't understand why it is not working
I am trying to count from the first tab: Advanced ANalytics, column F and the status in column S and return the vlaue on 2nd tab.
Can anyone help?
TY!
Thanks,
R.
There appears to a problem with the text "Advanced Analytics" in the formula.
I copied the text from the dropdown and it now works
=COUNTIFS('UK Request Type KPIs'!$F$17:$F553,"Advanced Analytics", 'UK Request Type KPIs'!$S$17:$S553,T3)
thank you John. I`ll take a look thank you
The data validation lists refer to external links, so it's not possible to work with this file to troubleshoot the issue. Sorry.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Try this:
=COUNTIFS('UK Request Type KPIs'!F17:F53,"Advanced Analytics*",'UK Request Type KPIs'!S17:S53,"No Changes*")
The star symbol helps with wildcards, there was also no reference to the first tab in your formula.
There is a trailing space in your formula after the word Analytics. Remove it, and it works
Formula:
Please Login or Register to view this content.
thank you all. The wildcard solution seems to work!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks