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

Cathi R
Cathi R ✭✭
edited 02/14/22 in Formulas and Functions

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.

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.

Answers

  • Sameer Karkhanis
    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
    Cathi R ✭✭

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

  • 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

    Need more help? 👀 | Help and Learning Center

    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!