Need help finding a way to shorten a complex formula

[KRE]

Any way to shorten this formula?

=IF(A328="","0",(XLOOKUP(A328,$A$30:$A$186,$N$30:$N$186,"")*C328)+(XLOOKUP(A329,$A$30:$A$186,$N$30:$N$186,"")*C329)+(XLOOKUP(A330,$A$30:$A$186,$N$30:$N$186,"")*C330)+(XLOOKUP(A331,$A$30:$A$186,$N$30:$N$186,"")*C331)+(XLOOKUP(A332,$A$30:$A$186,$N$30:$N$186,"")*C332)+(XLOOKUP(A333,$A$30:$A$186,$N$30:$N$186,"")*C333)+(XLOOKUP(A334,$A$30:$A$186,$N$30:$N$186,"")*C334))

 

[Fluff]

Try

=IF(A328="",0,SUM(XLOOKUP(A328:A334,$A$30:$A$186,$N$30:$N$186,0)*C328:C334))

 

[KRE]

That's worked!!! Thank you.

 

[Fluff]

You're welcome & thanks for the feedback.