Sumif to Sumproduct

[paulcherianc]

Hi

Can anyone help me to convert the below sumif to sumproduct

=SUMIF('G:\ACCOUNTS\ACDOC\01. Accounts Monthly Reporting\2016\2016.06\Accruals\[201606 Trial + Results.xlsx]Sheet1'!$A$12:$A$269,$C28,'G:\ACCOUNTS\ACDOC\01. Accounts Monthly Reporting\2016\2016.06\Accruals\[201606 TrialB + Results .xlsx]Sheet1'!$I$12:$I$269)

 

[DavidCBzz]

Hmm this brings back memories… havent used it in a while but I’ll give it a go

[FONT=&quot]''=SUMPRODUCT((A1:A10=E1)*(C1:C10))

[/FONT] Although range names may work better

Attached a txt file, should be able to copy/paste into excel

Here is a good link, this cat went all out on the explanation of SUMPRODUCT.. Impressive

[FONT=&quot]xldynamic.com/source/xld.SUMPRODUCT.html [FONT=&quot]([/FONT][/FONT]Cheated on the link, sorry)

good luck, hope it helps,