Will each item have the exact same value on each row?

What/where is your list of values for each item?

If you have a datalist with these values, you can incorporate a Vlookup()
function to multiply it's return by the Countif() function.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Mac" wrote in message
...
I have this spreadsheet that I created to count activities for the day. I
added a drop down for specific choices so I can graph the results for
example
Item A, Item B, and Item C. There is a total of the number of Item A's on
another sheet using the COUNTIF. How can I count numbers next to the Item
A
or Item B?

Item A listed 10 times will display the number 10 using the CountIF. If
Item A has a 2 next to it, then I will need to display 20. Is there a way
of
doing this?