Forum Discussion
Solved
HELP WITH FORMULAS TO AUTO-POPULATE A TABLE
I am looking for help with the attached sheet, where I have student names in one column and would like to extract their marks in English scored in H1 and H2. In the current sheet I have entered the ...
shyam_amara , you are welcome. Another useful function is IFERROR() to wrap any error, not only #N/A
An alternative strategy using SUMIFS to return the required values.
= SUMIFS( Results[English], Results[Match Number], match, Results[Student Name], Class1Name )
I have chosen to enter the formula as an array formula but implicit intersection will also work.