SUMIFS and AVERAGEIFS functions return "#VALUE!" Error

[Mytab2022]

Hello,

Is there a way to get around having #VALUE! Error from SUMIFS and AVERAGEIFS functions due to formula extracting data from closed workbook?

[#2 · Accepted solution]

@Mytab2022 

Use SUMPRODUCT() or Power Query.

[#3]

@Detlef Lewin 

Thank you, wasnt sure SUMPRODUCT would work but i have now followed through some explanation on that.