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

Options
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 ✭✭✭✭✭✭
    Options

    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 ✭✭
    Options

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

  • Genevieve P.
    Genevieve P. Employee Admin
    Options

    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!