What i want here is the total for a particular id. I have included sample output which can give u a clear idea of what i want. I am stuck on this please help me out.
Thank You
What i want here is the total for a particular id. I have included sample output which can give u a clear idea of what i want. I am stuck on this please help me out.
Thank You
In I3 try:
=SUMIF(A:A,TEXT(H3,"000"),C:C)+SUMIF(A:A,TEXT(H3,"000"),E:E)
And copy down.
Sorry but i want the column h and i both as the output!!
OK, try this in H3, confirmed with Ctrl-Shift-Enter, not just Enter, and copied down.
=IF(ROW(A1)>SUMPRODUCT(--(ROW($A$2:$A$500)=IFERROR(MATCH($A$2:$A$500,A:A,0),0))),"",INDEX(A:A,LARGE(INDEX(ROW($A$2:$A$500)*(ROW($A$2:$A$500)=IFERROR(MATCH($A$2:$A$500,A:A,0),0)),0),SUMPRODUCT(--(ROW($A$2:$A$500)=IFERROR(MATCH($A$2:$A$500,A:A,0),0)))-(ROW(A1)-1))))
The formula in I3 becomes:
=IF(H3="","",SUMIF(A:A,H3,C:C)+SUMIF(A:A,H3,E:E))
Also copied down.
Is that what you were after?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks