Trouble with XLOOKUP

[ar3inc]

I am having trouble with the XLOOKUP formula on a simple workbook I use to track the details of different jobs/invoices.  One sheet has the invoices listed with the details while the other sheet has a running list of expenses with a list and its association to an invoice.  

=SUM(XLOOKUP($E6,ExI,ExV))

I have the cells carrying the invoice label named ExI while the cells with the expense value named ExV. 

Despite trying to get a total of the expense I only get one value returned in the cell.

[#2]

@ar3inc I believe you need:

=SUMIF(ExI,$E6,ExV)

in stead.

XLOOKUP returns a single value as explained in the MS help section: