Ignore N/A in INDEX MATCH sum

Hi,
I have the following formula:

=INDEX(Daily_Data!$E:$E,MATCH(C$2&$A$1,Daily_Data!$A:$A,0))+INDEX(Daily_Data!$E:$E,MATCH(C$2&$B$1,Daily_Data!$A:$A,0))+INDEX(Daily_Data!$E:$E,MATCH(C$2&$C$1,Daily_Data!$A:$A,0))

Sometimes one of the criteria does not exist and therefore instead of returning the result for the other 2, it will return #N/A.

How can I get around this? I could put IFNA then 0, however when ALL 3 don't exist I want to return "" blank.

Thanks

Will there be only 1 (or 0) match for each criteria in column A ?

You could try

=SUMPRODUCT(SUMIF(Daily_Data!$A:$A,C$2&$A$1:$C$1,Daily_Data!$E:$E))

Then to return "" if the result is 0

=IFERROR(1/(1/SUMPRODUCT(SUMIF(Daily_Data!$A:$A,C$2&$A$1:$C$1,Daily_Data!$E:$E))),"")

Jonmo1, that is great, returning values where required and blank cell if there is an error
=IFERROR(1/(1/SUMPRODUCT(SUMIF(Daily_Data!$A:$A,C$2&$A$1:$C$1,Daily_Data!$E:$E))),"")

Thank You

You're welcome.