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!
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
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
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.
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
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 will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Suggested Courses
Course of the Month14 days, 12 hours left to enroll
649 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.