General discussion
Thread display: Collapse - |
All Comments
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Excel formula, text in column to a value
I need a formula that will take the values of Tony and Fred in the column D, and calculate the value the total (=6).
I can use the formula =COUNTIF(D1:D10,"Fred") and this will give me 2, but I really need to say give me the total of Tony and Fred?
Not being an expert with excel I've run out of ideas?