Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

=sum but number = other values

0

ok so i need a cell to add up other cels so like =sum(a1:a20) but i need it to work out that 1=15 2=10 3=5 so a1=1 a2=3 a3=0 a4=2   which would be answer of 30 a1=15 a2=5 a3=0 a4=10

Answer
Discuss

Answers

0

Will this do what you want?

=(COUNTIF(A1:A20,1)*15)+(COUNTIF(A1:A20,2)*10)+(COUNTIF(A1:A20,3)*5)
Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login