How can we write the formula that finds the total number of students as in the green part? Please find attached Excel File.
How can we write the formula that finds the total number of students as in the green part? Please find attached Excel File.
Last edited by student_md; 01-29-2023 at 01:50 PM.
=sumif($a$2:$a$8,"*(" & left(f2,3) & "*",$b$2:$b$8)
Ben Van Johnson
Another optionFormula:=SUMIFS($B:$B,$A:$A,"*("&TRIM(F2)&"*")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks