Thread: Counting Various Numerical Characters and Summarizing

I looked around the site and didn't see anything pertaining to my question.

I'm trying to use excel to make a count of numbers ranging from 1-20, but I want excel to count those numbers a number of times equal to a corresponding number on the same row.

For example, in a set of numbers, the function should identify the which number equal "1". In this case, I want "1" is a character and not a value. If the number is 1 then it should count that number a number of times equal to the number in the next column on the same row. So if I have "1" in B1 and "3" in the C1, then the formula finds a "1" in B2 with a 4 in C2, it should output 7.

Thanks for the help

This did not work. I'm using office 2008 on a mac, but it should work the relatively the same. When I removed the "#" around the 1 it the function "worked". But it did not produce the values I wanted.

This might be easier. The value of the character checked should always be 1 in the function, therefore having no affect on the outcome of the number. The only values that matter are those in the quantity column.

So maybe it would be better if the function did this: If the character in A2:A20 is 1, then the corresponding value is added.

To clarify,
a 3
b 4
a 5

That should equal 8. Because the function would not count the b, but it would add the 3 and the 5 because they had the correct character in the A column.