We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Course Of The Month
3 days, 2 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Counting cells against conditions in 2 columns
Posted on 2011-02-17
I run Excel 2002 in Windows 7.
I have a sheet which grades many examples of 3 items (called A B and C, say) into 3 grades (1, 2, and 3). Each example gets a new row.
Col A contains the Item name, Cols B-H contain other data, Cols I-O contain tests and Col P contains the calculated grade for that example.
I need to count how many examples of Item A in Col A are graded as a 3 in Col P, etc.
Could someone guide me?
Thanks in advance
Tony
I have a sheet which grades many examples of 3 items (called A B and C, say) into 3 grades (1, 2, and 3). Each example gets a new row.
Col A contains the Item name, Cols B-H contain other data, Cols I-O contain tests and Col P contains the calculated grade for that example.
I need to count how many examples of Item A in Col A are graded as a 3 in Col P, etc.
Could someone guide me?
Thanks in advance
Tony
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3
- +1
6 Comments
Active today
sear AWS,
you could use a sumproduct for this.. I will give you the correct formula when you can give me a example.
I run dutch version so paste the formula will not work ...
Kr
Eric
you could use a sumproduct for this.. I will give you the correct formula when you can give me a example.
I run dutch version so paste the formula will not work ...
Kr
Eric
If you just want to count the number 3 in column A, you can use a simple COUNTIF():
=COUNTIF(A:A,3)
If you want to count using multiple criterias, you need to use SUMPRODUCT() function, like this example:
http://excel-user.blogspot.com/2009/10/sumproduct-sum-values-based-on.html
If you post a sample data, I can give you a more realistic answer.
jppinto
=COUNTIF(A:A,3)
If you want to count using multiple criterias, you need to use SUMPRODUCT() function, like this example:
http://excel-user.blogspot.com/2009/10/sumproduct-sum-values-based-on.html
If you post a sample data, I can give you a more realistic answer.
jppinto
If I'm not mistaken, after reading again you question, this is the formula that you want:
=SUMPRODUCT((A:A="A")*(P:P
It will count how many items "A" you have on column A that have a grade "3" in column P, right?
jppinto
=SUMPRODUCT((A:A="A")*(P:P
It will count how many items "A" you have on column A that have a grade "3" in column P, right?
jppinto
Featured Post
We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
A little background as to how I came to I design this code:
Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Suggested Courses
Course of the Month3 days, 2 hours left to enroll
695 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.