• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1116
  • Last Modified:

Make this against LAST item? =IF(COUNTIF(A$1:A1,A1)=1,SUMIF(A:A,A1,B:B),"")

from another Q_28146015
Do I need a sum on each row even if A1 is repeated? No.
I could invoke SUMIF just on the first row for each repeated value,

 i.e. like

=IF(COUNTIF(A$1:A1,A1)=1,SUMIF(A:A,A1,B:B),"")

Question:
What I would like is the sumif value against the LAST instance of the matching criterion.
Blank criterion  to refer to a different column, same row.
0
Anthony Mellor
Asked:
Anthony Mellor
1 Solution
 
barry houdiniCommented:
If you are using a finite number of rows (say 1000 but you can adjust that) then try

=IF(COUNTIF(A1:A$1000,A1)=1,SUMIF(A$1:A1,A1,B$1:B1),"")

or for an indefinite number of rows

=IF(COUNTIF(A$1:A1,A1)=COUNTIF(A:A,A1),SUMIF(A$1:A1,A1,B$1:B1),"")

regards, barry
0
 
Anthony MellorChartered AccountantAuthor Commented:
this is the one I wanted, points for this: =IF(COUNTIF(A$1:A1,A1)=COUNTIF(A:A,A1),SUMIF(A$1:A1,A1,B$1:B1),"")

thanks

are you sure about that first one working with last item?

follow up in a moment
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now