sum column D based on column A

  • Thread starter Thread starter anthony
  • Start date Start date
A

anthony

I have a worksheet having claim numbers in column A invoice numbers in column
B and invoice amoiunts in column D. A single claim may have one or more
invoices

How can I have claim totals/sum/amount in column M?(Prefarably in the same
row as the last invoice for each claim)
 
Hi Anthony

Try
=IF(COUNTIF($A$1:$A1,A1)=COUNTIF($A$1:$A$12,A1),SUMIF($A$1:$A$12,A1,$D$1:$D$12),"")

Amend ranges to suit
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using AND and SUMIF function together 5
Sum multiple invoice number 6
Sum If Help 5
Data Validation to exclude blank cells 6
Find Duplicates 9
Need help with SUMPRODUCT Formula 10
template creates invoice - how to create summary worksheet? 13
select a range in a column 4

Back
Top