Question about Microsoft Excel for PC

# Excel Formulas! Hi, I have a column with the following data: Eg. A1=2007T3P; A2=2008T4HD; A3=2006T1D and so on. Now I want to count the number of "P", "HD" and "D". I just want it to take the character "P", "HD", "D' and ad it up for me, i,.e the number of times they appear. I have put in a string formul, but it takes "HD" and counts it three times for me. It takes it as "H", "D" and "HD". But I just want to take it as "HD" ...hope I have not confused you. Help in solving my problem is much appreciated. Thanks Candy:)

Posted by on

×

• Level 3:

An expert who has achieved level 3 by getting 1000 points

Superstar:

An expert that got 20 achievements.

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

• Microsoft Master

Does the search formula help?

Posted on Sep 03, 2008

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### Construct both an ungrouped and a grouped frequency distribution for the data given below: 139 130 128 134 140 139 136 130 136 128 138 137 134 128 127 136 140 132 141

Sorry to disappoint you but I will just give you directions to do it yourself.
Ungrouped
First sort the data in ascending order (from lowest to highest value)
Create a two-column table
In the first column enter a data value.
In the second column enter the frequency of a data item
Count how many times one particular data value appears in the set (how many repetitions). If it appears only once, its frequency is 1; twice, frequency 2, etc.
For each single (different) data value complete the frequency column.

Grouped
For grouped data representations you create classes: A class is just an interval of values, for example between [125, 130[
For each class interval you create, count how many data values fall within the interval. For the class given as example it will encompass all values between 125 and 129, It I counted correctly its frequency is 4.
Complete the frequency table for the class.

How many classes should you create? Usually this information is given to you. If not, create a moderate number of classes (4,5) It depends on the span of the distribution (highest value- lowest value). The intervals should have equal length. Read your instructions.

Sep 02, 2012 | Office Equipment & Supplies

### How do I get a meter reading of number of copies?

Here you go.

1. Press the [Reports] button on the Control Panel

2. Press the [Up] or [Down] arrow until 'Systems Data' is displayed on the Display Screen.
3. Press the [Enter] button.

The System Data list will be printed with the following information:
• Total Page Counts: Total number of pages printed
• CRU Prints: Number of pages printed using the current Toner (Dry Ink) Cartridge
• Replaced Toner Counts: Number of new Toner Cartridges installed in the machine
• Replaced Drum Counts: Number of new Drum Cartridges installed in the machine
• Current Drum Page Counts: Number of pages printed using the current Drum Cartridge
• Platen Scan Page Counts: Number of pages scanned using the Document Glass
• ADF Scan Page Counts: Number of pages scanned using the Automatic Document Feeder (ADF)

Feb 10, 2010 | Xerox WorkCentre M15i Laser Printer

### Hi i need the code for one for all urc-7562 for my tv goodmans GTV42P3

Goodmans:
0036 0072 0037 0009
0264 0516 0179 0374
0487 0371 0499 0556
0343 0235 0035 0480
0217 0335

Oct 23, 2009 | One For All URC 7740 Remote Control

### Count the number of open and closed order status per owner

My suggestion is to use a Pivot Table.  Follow these instructions:
Click on column A1 - then in the menu bar click DATA > Pivot Table and Pivot Chart Report.

Click NEXT on step 1 of pivot table wizard.
For step two you will want to highlight all of the data on your sheet.  then click next.
Choose NEW WORKSHEET for step 3 of the pivot table wizard and click finish.
Once the Pivot Table sheet opens, drag the STATUS field into the top left corner of the pivot table view, where "drop column fields" and "drop row fields" meet.  Next drop another instance of the STATUS field into the "drop row fields here" column.  And lastly drop the OWNER field into the "drop column fields here" section.  You should now be viewing a report showing you exactly what you were looking for.
Regards,
Joe

May 07, 2009 | Microsoft Excel for PC

### I have a column A with repetitive dates. Column B with repetitive names Example: 05/01/09 a 05/02/09 b 05/03/09 a 05/01/09 c 05/04/09 a 05/01/09 d 05/03/09 c I want to count how many a,b,c,... I have for...

Use 3 pivot tables, put a, b, and c in the row areas and "Count of a", "Count of b" and "Count of c" in the data sections. That will give you a count of each date for each column

Apr 28, 2009 | Microsoft Computers & Internet

### Count with 2 or more criteria

Can you do this using a pivot table where columns B & C are Row Fields and Count of B&C is data fields.

Jan 17, 2009 | Microsoft Excel for PC

### Excel formulas

{=max(if(category column = category in query, price data column))}

Nov 18, 2008 | Microsoft Excel for PC

### LOOK UP AND ALLOCATE

Hi,
Could you write the column names from both the sheets seprately, and one data eg. that you need. It would be easier to understand the problem.

Thanks
Proton

Oct 17, 2008 | Microsoft Excel for PC

It could have a virus or simply too much data in it or too much data linked to it. Try doing a copy of the whole spreadsheet, and then paste the data into a new spreadsheet. If it doesn't contain too many different formulas, try pasting only the values, and then replace the formulas manually. You might also try just deleting the links, if there are any. If this doesn't solve it, reply to this thread and let us know.

Hope this will FixYa!!!

Sep 30, 2008 | Microsoft Excel for PC

### BASIC EXCEL FORMULA

Are you looking to solve any particular problem?--- because there are a huge number of possible formulas in Excel.

However, in my opinion, the most commonly needed ones are addition, subtraction, division, multiplication, and summing.

columns: A B C D
rows
1 20 3
2 10 4
3 15 2
4 1 2 3

Then suppose you type in the following formulas (in the D column):

columns: A B C D
rows
1 20 3 =A1+B1
2 10 4 =A2-B2
3 15 2 =A3*B2
4 1 2 3 =sum(A4:C4)

Then the following answers will appear in the D column:

columns: A B C D
rows
1 20 3 23
2 10 4 6
3 15 2 30
4 1 2 3 6

Sep 29, 2008 | Microsoft Computers & Internet

#### Related Topics:

53 people viewed this question

Level 3 Expert

Level 3 Expert