sum of same name

[delta]

i want to same item is opposite every item then sum. like item A3 match D3 item then sum other wise value of A3 is shwon in C3 i attcha the sample file i want to result F3 cell
how it is made

 

[Smallman]

Hi Delta

This formula should see you right.

=SUMIFS($B$3:$E$9,$A$3:$D$9,$A3)

Take care

Smallman

 

[delta]

hi
but sum shown is 0 pls send sample file so urgent

 

[NARAYANK991]

Hi ,

See this file.

The formula Marcus posted is available in Excel 2007 and later versions ; if not , you need to use an array formula. Both are given in the attached file.

Narayan

 

[Smallman]

The file provided is XLSX which means it should work on the above.

 

[Somendra Misra]

Hi delta,

like item A3 match D3 item then sum other wise value of A3

If I understood the problem correctly, this can be achieved with a simple if,
=IF(A3=D3,B3+E3,B3)

Correct me If I am wrong.

Regards,

 

[Smallman]

=IF(A3=D3,B3+E3,B3)

Somendra - That is fine if the data stays in the same place. Most datasets are more dynamic than that and if any of the data points move then above will not produce the desired result.

Take care

Smallman

 

[delta]

thanks very much SM your r genius