Count cells w/values in column if the data in column a matches

Count cells w/values in column if the data in column a matches

Post by bWRjZ3B » Wed, 14 Jan 2009 08:55:00

Thank you, however this is not working. Let me try and give more detail.

I am using excel 2000

Data is stored in one worksheet named Jan, in another workshet I have the
summaries and that is where I need to enter the formula.

Worksheet Jan has column F with sales people initials, and columb O with
sales numbers of accessories. In the summary sheet I need to know: Of all
the sales a sales person had, how many had also accessories sales.

Based on your reply, I tried the following, but am getting an error.

I appreciate the help.................................

Thank you

1. "Matching" column A's values in column B

2. Counting A's in a table column 1, F's in column 2, etc...


I have a database where you can type in students' responses to
questions on a test.
I was able to create a count on a query that shows me how many
people selected the answer A (the correct answer) to question 1, F to
question 2, etc... I would like to have my query show the responses
for all of the questions that way I don't have to open
up 25 different queries to get a sense of how many students got each
question right.

When I just do a query with a count for question 1, the function works
accordingly telling me I have 10 A's, 2 C's, etc... However, when I
add more columns to show question 2 it
still ultimately shows me how many A's were selected for the first
question, but it does not put all the A's together as the table below
shows. Instead, it has three categories for A, 2 for D, etc... (the
numbers do add up correctly though). I'm not sure why it is doing
that. Any ideas?? I've included the SQL code below the table.

SA1 CountOfA SA2 CountOfF
10 10
A 8 F 8
A 1 H 1
A 1 J 1
C 1 F 1
D 1 F 1
D 2 G 2
E 1 F 1

Here is the SQL code that is producing this table.

SELECT Table1.SA1, Count(Table1.A) AS CountOfA, Table1.[SA2],
Count(Table1.F) AS CountOfF
FROM Table1
GROUP BY Table1.SA1, Table1.A, Table1.SA2, Table1.F;

much appreciative,

3. Count column b if column a equal cell value

4. How get cell count and match total column value

5. highlight cells in 2 columns that don't match cells in 2 other columns

6. Highlight row and column for the current cell,anyone re-write it to Add-Ins?

7. DBD::mysql::st execute failed: Column count doesn't match value count at row 1 a

8. "Column count doesn't match value count at row 1"

9. :mysql::st execute failed: Column count doesn't match value count at row 1 a

10. Count unique values in one column if values in corresponding column are null?

11. INSERT statement falied: Column count doesn't match value count at row 1

12. Matching one column against another column of data to show the same amount of data.

13. Count data in one column indicated by data in another column

14. Find max value in one column and return the value of corrosponding cell in different column