How do I get the count of a result from 2 other columns?

Cathi R

I am trying to calculate the count of my Interview Results based on if the 1st attempt was Interview Scheduled and or the 2nd Attempt was Interview Scheduled.

Screen shots provided. Thank you.

Interview Results.PNG

This is what I have so far. =COUNTIFS({First Attempt Result}, "Interview Scheduled", {2nd Attempt Result}, "Interview Scheduled") = SUM({Interview Results})

It returns a value of Invalid Column Value.

Sameer Karkhanis

Assuming the values in the two columns are mutually exclusive (aka cannot have Interview Scheduled for the same row in both columns) the simple formula that can be used is,

=COUNTIF([First Attempt Result]:[2nd Attempt Result], "Interview Scheduled")

Cathi R

Thank you for the insight. It does help a little but looking for a different end result.

Genevieve P.

Hi @Cathi R

Can you explain what the end result is that you're looking for? Sameer's formula should work if you want to calculate this within the same sheet. However if you're looking across sheets, I would add two separate COUNTIF statements together, like so:

=COUNTIFS({First Attempt Result}, "Interview Scheduled") + COUNTIFS({2nd Attempt Result}, "Interview Scheduled")

The reason your first formula didn't work is because a COUNTIFS will see the comma between your ranges as an AND, so it would only be counting rows where both sets of criteria were matching (both cells in the same row said "Interview Scheduled").

Let me know if this works for you!

Cheers,

Genevieve