Ladkisson
asked on
Sum Formula for selective values.
Hello!
Column A has a list of different repetitive codes and Column B has a corresponding $$ for each code. I need a function that will give me only one $$ value for each code and will exclude all others. Please refer to the attached file.
Sum-Formula-for-selected-values.xlsx
Column A has a list of different repetitive codes and Column B has a corresponding $$ for each code. I need a function that will give me only one $$ value for each code and will exclude all others. Please refer to the attached file.
Sum-Formula-for-selected-values.xlsx
ASKER
Sorry, I missed a step and explained it wrong. I don't need an overall "Total". Column "C" should have a $$ value for each code (but only one, all others need to be excluded). Please refer to the attached file. Thank you!!
Sum-Formula-for-selected-values.xlsx
Sum-Formula-for-selected-values.xlsx
ASKER
The suggested formula did not work. The attached file has more data for you to better understand what I am looking for. I filtered on the first code to show you that your formula is still pulling both $$ amounts. And it should only be referencing one. Please advise! Thank you!
Sum-Formula-for-selected-values.xlsx
Sum-Formula-for-selected-values.xlsx
Use this formula...
=if(countif(A$1:A2,A2)=1,B 2,"")
Simply drag this and it will do what you are looking for..
Saurabh...
=if(countif(A$1:A2,A2)=1,B
Simply drag this and it will do what you are looking for..
Saurabh...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
pls try as Array formula (ctrl-Shft-Enter)
=SUM(B2:B14/COUNTIF(A2:A14
Regards