Forum Discussion
Solved
COUNTIFS to return values in a table
Hello! Working with a large dataset and seeking to break up the data into different columns based on amount. I am looking to separate projects <100K, projects >=100K, projects <=1M, and projects >1M...
Thank you everyone for your help!! I was completely overcomplicating and really just needed a simple IF= statement. But this was a great learning experience!!
How about this for Projects <100:
=LET(
TPMList, FILTER($A:$A, ($A:$A<>"") * ($A:$A<>"Project Manager") * ($E:$E<>"N/A")),
CurrentPM, A2,
FilteredBudgets, FILTER(Table_Projects[Current Budget GR],
(Table_Projects[Project Manager]=CurrentPM) *
(Table_Projects[Period]=MAX(Table_Projects[Period])) *
(Table_Projects[Current Budget GR]<100000)
),
ProjectsCount, IFERROR(COUNTA(FilteredBudgets), 0),
IF(ProjectsCount = 0, "None", ProjectsCount)
)
This looks the same as the first test I posted...
