Forum Discussion
Solved
Text with "*[text]*" with SUMPROD function
Hello ! I would like to look for how many subjects are late for each subdivision and by how much (more than 3 months, less than 6 months, and more than 6 months), but the raw data is an extractio...
You can use SUMIFS:
SUMPRODUCT works as well
=SUMPRODUCT(
($B$2:$B$23 = "Late") *
($D$2:$D$23 <= EDATE($H$1,-3) ) *
( $D$2:$D$23 > EDATE($H$1,-6) ) *
ISNUMBER(SEARCH("\" & H$25, $C$2:$C$23))
)