# Index+Match+Sumif

#### ScottyDundee

##### New Member
I am doing an index+match of a portfolio value using a client identifier plus date. However the client can have more than 1 account (using the same identifier) and I need to add sumif to the formula. As the date being looked at can fall on a weekend I have had to expand the formula so that the last working day figure is looked up.

Currently I am using the below formula:
=IFERROR(IFERROR(-INDEX('Client Data'!1:1048576,MATCH(Performance!\$O\$6,'Client Data'!\$A:\$A,0),MATCH(Performance!R1,'Client Data'!\$1:\$1,0)),-INDEX('Client Data'!1:1048576,MATCH(Performance!\$O\$6,'Client Data'!\$A:\$A,0),MATCH(Performance!R1-1,'Client Data'!\$1:\$1,0))),-INDEX('Client Data'!1:1048576,MATCH(Performance!\$O\$6,'Client Data'!\$A:\$A,0),MATCH(Performance!R1-2,'Client Data'!\$1:\$1,0)))

The index and match cells are highlighted in red below:
 Semi-Annually 01-Jun-13 01/12/2016 01/12/2016 Portfolio Value £62,170.56 % Change 6 Months 100.0 BC001232456 Inflows/Outflows

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

How do I add sumif to the formula so that the Portfolio Value will total them?

### Excel Facts

Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Replies
3
Views
1K
Replies
4
Views
715
Replies
7
Views
253
Replies
0
Views
291
Replies
10
Views
864

1,191,134
Messages
5,984,862
Members
439,921
Latest member
Neocold

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back