Forum Discussion
AshleyLeach
Feb 13, 2024Copper Contributor
Match / CountIfs or other?
Is anyone able to help me with a formula that I have been struggling with for some time now. I would like to calculate the value added score across the whole group of learners from their Projected Gr...
AshleyLeach
Feb 24, 2024Copper Contributor
Thank you Patrick2788 that works great. When I have used this in my document, it is copying blank cels as 0 into the other sheet. Is there anyway of removing these?
Also, is there a way of using this formula to search across more than one sheet a data row?
Huge thanks,
SergeiBaklan
Feb 25, 2024MVP
Another option is to return empty strings instead of blanks
=LET(
f, FILTER(Demo, Demo[Color] = "red"),
SUBSTITUTE(f, "", "")
)