sumif?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two columns

one has "id" and column 2 has amount

a 5
b 10
c 15
a 5
c 15

All id has same amount.
what I want is total of all unique id's
i.e. 30 in this case

The number of rows/ records can go up and down.
any takers?
 
Try this:

With
your posted example in A1:B5

C1: =SUMPRODUCT(1/COUNTIF(A1:A5,A1:A5)*B1:B5)

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 

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

Macro to add numbers in a text string 5
Excel Subtracting multiple columns from another column 3
sumif with multiply-rks 7
How to update data from multiple sheets to one specific sheets 4
Sumif function 4
Filtering of data in a master excel sheet from multiple sheets 3
Column sum incorrect upon subtracting 6
Identify condition using multiple criteria WITHOUT sumproduct?.. 14

Back
Top