Requirement: Identify all items within a group if any of the items in that group meet a condition.

Solution: This time I use the SUMPRODUCT function for a quicker solution.  SUMPRODUCT can be used to count with conditions (within the same group).

 

Watch my YouTube video

 

Subscribe to my YouTube channel and learn more!

See my free templates here!

Post a comment