Using SUMIF or SUMPRODUCT

[Excel-Access]

Hi

Could someone please help me build a formulae to pull data from two tabs.

No sure If I have to use SUMIF or SUMPRODUCT or Other.

Thanks

 

[Nebu]

Hi:

Use the formula

=SUMPRODUCT(($A2=Sheet2!$A$2:$A$15)*(C$1=Sheet2!$R$1:$Z$1),Sheet2!$R$2:$Z$15)

Thanks

 

[Excel-Access]

Thank you very much Nebu.

 

[bosco_yip]

Or, in the case of using SUMIF function

In C2, copied across to K2 and all copied down :

=SUMIF(Sheet2!$A:$A,$A2,Sheet2!R:R)

Regards
Bosco

 

[Excel-Access]

Thank you very much Bosco

 

[Hui]

or C2:
=SUM(IF(Sheet2!$A$2:$A$15=$A2,Sheet2!R$2:R$15,)) Ctrl+Shift+Enter
Then copy down and across

 

[Excel-Access]

Thank you Hui for alternative option.

Much appreciated my friend.