HI - I have typed a formula to sum the list of values based on multiple conditions; my formula goes like this
=SUM(IF('Detailed Mapping status'!B4:B180='Detailed Mapping status'!Z1,IF('Detailed Mapping status'!C4:C199='Detailed Mapping status'!AA1,'Detailed Mapping status'!F4:F1215)))
I used...