I have seen the COUNTIFS(Table1[Service Status],{"Complete","In Work"}) type of formulas, but i am wanting the portion between the curly braces to be dynamic pulled from another table.
Similar to the IN function within SQL.
I have tried multiple things and searched for a while now, so any assistance is greatly appreciated. :P
Last edited by bahalzamon; 10-19-2023 at 01:50 PM.
Pretty sure that only works with constant values, not cells or ranges. There's probably a way though.
I don't have the Table but it would look something like this:
Formula:
Please Login or Register to view this content.
I'm sure there are better ways.
Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
The criteria-parameter of the function COUNTIFS can be a dynamic table.
For example:
Please Login or Register to view this content.
thank you, ill give this a shot.
i was on a bit of a deadline so i just made a simple helper column in the data source with a vlookup and iferror.
i have never used the let command before.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks