Search and count?

[Closed]
Report
-
Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
-
Hello,

Using Excel and trying to count and display results for Column A (let's say it has test grades A, B, C, or D for each person) but I need this based on Column H's value (ie- I only want a count of the grade if the text string "Junior" is in Column H of that row). Is there a way to do this using only functions available in Excel? Using coding is out, as I could use it on my machine, but others would be blocked due to security settings. :) Thanks for any advice.

1 reply

Posts
2817
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 14, 2021
486
Hi :)'s,

Use this formula:
=SUM((A1:A14="A")*(H1:H14="Junior"))

This is an array formula which needs to be confirmed by hitting Ctrl+Shift+Enter.

When doing correctly the formula will then be enclosed by curly brackets like:
{=SUM((A1:A14="A")*(H1:H14="Junior"))}

Best regards,
Trowa