Trying to sum duplicate descriptions when using an array

[Iain Garey]

Hi All

I am currently using the below formula to extract various fields from a spreadsheet:-

{=IFERROR(INDEX(Funding_Stream_All_Data.rdl!$I$1:$I$999999,MATCH(1,(Funding_Stream_All_Data.rdl!$B$1:$B$999999=$C$8)*(Funding_Stream_All_Data.rdl!$D$1:$D$999999=$A19),0)),"0.00")}

Which would be fine if the description in column B of my data only appeared once.

How do I sum the total of all those that have the same description?

Data Example

Column A Column B Column C

Code Description Value
SL10107 Test Data £100.00
SL10107 Test Data £100.00
SL10107 Test Data £100.00

Using the formula {=IFERROR(INDEX(Column C,MATCH(1,(Column A=SL10107)*(Column B=Test Data0,0)),"0.00")} I get the answer £100, i.e. it is Matching the Code SL10107, and then matching the Description of Test Data and then returning the first value, £100. However I would like to sum these entries and get the answer of £300

Thanks

Iain

[amit.wilson]

Hi I,

welcome to the forum. Do you want to try:

Please Login or Register  to view this content.

as an array function, i.e. press CTRL+SHIFT+ENTER to enter.

Cheers