View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jas Jas is offline
external usenet poster
 
Posts: 42
Default Help: Using CONCATENATE (and a COUNT?) for a total result

I am trying to get a formula to work but says invalid each time. I am at a
loss.

In Column C, I am using the formula =CONCATENATE((COUNTIF(A1:A10,"Item
1")+COUNTIF(A1:A10,"Item 2"))," = Total Items").
In Column B is the object (reward points for this example) I want to count
against Column C.

In Column A, how do I get the result?

Example:
Item 1 = 20 points
Item 2 = 50 points
I have reward points for every Item I sell.
Result, how many reward points do I get against all Items sold?

So, 6 Item 1s equals 720 points (6x20=720).
How to formulate this please?