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
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
Will this do what you want?
=(COUNTIF(A1:A20,1)*15)+(COUNTIF(A1:A20,2)*10)+(COUNTIF(A1:A20,3)*5)