Question about Microsoft Excel for PC

# EXCEL FORMULA PC

Ello, On an Excel spreadsheet if i had a list of names in Column A and a list of items in column B Does anyone Know the formula To count how many times say Fred that is in column A has a Red Ball in column B. I posted my problem acouple of weeks ago but under computer games so this time it is in the right place so hopefully i get an answer..

Posted by on

• Level 2:

An expert who has achieved level 2 by getting 100 points

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

Vice President:

An expert whose answer got voted for 100 times.

• Expert

The easiest way would be to create a pivot table

with Column A and Column B being the row fields.

and count of Column A and B in data, you will have a summary of these in the data

Posted on May 22, 2009

The solution I've used in similar situations is to create a 3rd column C with the items in column A and column B concatenated.

C2 = A2 & B2
C3 = A3 & B3
C4 = A4 & B4
etc.

Then use COUNTIF function: =COUNTIF(C:C,"FredRed Ball")

Hope this helps.

Posted on May 28, 2008

• Level 1:

An expert who has achieved level 1.

Hot-Shot:

An expert who has answered 20 questions.

Corporal:

An expert that has over 10 points.

Mayor:

An expert whose answer got voted for 2 times.

• Contributor

The solution I've used in similar situations is to create a 3rd column C with the items in column A and column B concatenated.

C2 = A2 & B2
C3 = A3 & B3
C4 = A4 & B4
etc.

Then use COUNTIF function: =COUNTIF(C:C,"FredRed Ball")

Hope this helps.

Posted on May 28, 2008

## 1 Suggested Answer

Hi,
A 6ya expert can help you resolve that 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.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Good luck!

Posted on Jan 02, 2017

×

my-video-file.mp4

Complete. Click "Add" to insert your video.

×

## Related Questions:

### Excel Spreadsheet question

cells are referenced by column and row. columns use a letter reference and rows use a number reference. to reference pages use the page name. For example if you are entering a formula in a cell on a page named sheet2 and part of the information is located on the page named sheet1, you would use a reference as follows:

sheet1!C3 This reference is for the cell on the page named sheet1 in the third column and the third row.

Hope this helps

Apr 09, 2014 | Microsoft Excel for PC

### Formula reqd in MS Excel

hi-lite the whole spreadsheet
go to data and select auto filter
you will see that each column will have an arrow at the top for a pull down menu
click on the city you want and you will only see the hospitals in that city
be sure to save your changes and the autofilter will be saved

May 17, 2009 | Computers & Internet

### Excel lookup - match index array

The best solution may be to re-define the named columns, or to add new names to multi-column arrays, then use the VLOOKUP function.
Note that the "indexed" named cells must be sorted by the index column.

Test (this is a 2 year old question)... Please ignore ths following. The plus symbol does not display.
Upper key plus symbol displays:
Right plus symbol on number pad displays:
[Shift] Right plus symbol on number pad displays:
[Alt] [4] [3] displays:
slash/slash/plus displays: //
slash/plus/slash displays: / /
Plus Plus Plus displays:
upper Plus Plus Plus displays:
Shift Right plus plus plus displays:

end of plus test.. thanks.

Dec 09, 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.

Suppose you have the following numbers typed into your Excel spreadsheet:

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

### Percentages in Excel

No problem, Melinda, I am here to help!

If I understood correctly, your spreadsheet looks something like this:
A B C D
1 Question Yes No Total
2 Is sky blue? 20 2 22
3 Is world round? etc.

In this case, the formula for % of Yes would be: =B2/D2. This would give you a decimal point result such as 0.909091. Now if you want to make this look like a percentage in your spreadsheet, just do the following:
1) click on the cell where you have the division formula
2) clck on Format in the top menu bar
3) click on Cells
4) click on the Number tab (if you're not already there)
5) click on Percentage in the list of categories
6) click OK

To boil it all down to a simple principle, percentages are created in Excel by dividing the two numbers using a formula with "/" in it, and then formatting the result to look like a percentage instead of a decimal.

I might have misunderstood your question, and I have an idea of what else you might have been asking (and another slightly more complicated solution for it!), so please let me know if my first answer didn't hit the mark!

Good Luck!
Regards,
RichMTech

Aug 08, 2008 | Microsoft Excel for PC

### Should I use countif or if or what ??

hi this my id :dadu_mf@rediff.com plz send excel material

Mar 25, 2008 | Microsoft Excel for PC

### Excel 2007 spreadsheets

The most likely problem is that you (or somebody) has R1C1 reference style turned on.

In the TOOLS menu, choose OPTIONS and switch to the GENERAL tab. Look for the checkbox labeled R1C1 reference style. If it is checked, this will cause your symptoms.

Just uncheck the box and click OK.

I'm not sure what happens to existing formulas. If you (or somebody) has written formulas that rely on the R1C1 style, I don't know if they automatically get updated to the regular style or not, but that should be easy to discover.

Jan 10, 2008 | Microsoft Excel for PC

#### Related Topics:

151 people viewed this question

## Ask a Question

Usually answered in minutes!

Level 3 Expert

Level 3 Expert