I successfully use :
=SUMIF($A40:$A97,B2,Z40:$Z97) to find the variable in B2 in column A and return the value from column Z.
I want to find a value from a column which varies depending on the title of the row.
i.e. Column Z has a title in row 5 as Balance c/f and a date in row 6 as 2017. The...