Sumif Dependant Multiple Named Criteria Problem

[KC12345]

Gday. I have a issue that has me pulling out my hair. I have to report a value based on the following criteria : Its date raised, what type of valuation it is and it must be a reportable case. I have the following names " Date_raised, Value, Type_of_valuation (there are multiple types that are recorded on another sheet) and Reportable (Yes/No option). Presently I have the following "Sum(if(Date_raised_=A27,Value)*(Type_of_Valuation='Sheet1'!A2))} Works great - problem is that it does not take into account if it is reportable or not. please help

 

[KC12345]

That's what it was ! One row short in the "reportable" named size. thank you. So the first formula worked a treat - thank you so much

 

[Aladin Akyurek]

That's what it was ! One row short in the "reportable" named size. thank you. So the first formula worked a treat - thank you so much

You are welcome. What I did is to exclude the possibility of an error in the relevant ranges with the first 3 diagnostics, then focus on the additional range of Reportable. Since the latter cannot have a #VALUE! error (derived from your description), we could conclude with the last ROWS diagnostic that the size only can cause the observed error.