| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula needed to concatenate text with result from calculation | Excel Discussion (Misc queries) | |||
| Why does Concatenate formula show but not produce a cell result? | Excel Worksheet Functions | |||
| How to concatenate 3064 and 01 with 306401 as a result? | Excel Worksheet Functions | |||
| calculate count on 2006 total, 2005 total, etc... | Excel Worksheet Functions | |||
| UDF to evaluate result of concatenate() with additional arg. | Excel Discussion (Misc queries) | |||
Threaded Mode
