Sum of unusual data range

[kdraghu]

Hello,

I have a file in which A/c numbers and name and Incentive is given.
I want Sum of D2+D3+D4 (i.e Incentive)in Cell E2 or Cell E4 so this will be total Incentive received to Account number -1949651100000019 OR RAMESHWAR BABASAHEB PANDIT

Please assist .

Kapil

[modytrane]

can't open the file. can you try to upload it again?

[Fluff13]

Remove the merged cells, then put this in E2 & copy down
=IF(COUNTIF(B$2:B2,B2)=COUNTIF(B:B,B2),SUMIF(B:B,B2,D:D),"")

[AlKey]

Try this
Unmerge Cells in Column E

Now, Enter formula cell E2 and copy down

=IF(A2<>A3,SUM(D$2:D2)-SUM(E$1:E1),"")

[kdraghu]

Thank You.
It is showing exact result.

Kapil

[Fluff13]

You're welcome & thanks for the feedback

[kdraghu]

Dear AlKey and Fluff13,

Thank you for your assistance

Is there any by which we can make all similar account numbers or Name with separate colour or any type of marking where similar account numbers or Name are easily visible.

Thank You

[Fluff13]

Select A2:E546 & in conditional formatting > New rule > Use a formula
=ISEVEN(COUNTIF($E$1:$E1,">0"))
Select the format you want, then repeat the same steps & use
=ISODD(COUNTIF($E$1:$E1,">0"))

[kdraghu]

Thank You.
Its working.

Kapil

[Fluff13]

My pleasure & thanks for the Rep