COUNT MATCHING VALUES FROM TWO DIFFERENT COLUMNS ON A SEPERATE SHEET

Options

Hello,

What I first thought would be an easy formula has turned out to be quite a pain. I am trying to count the number of rows where one column matches the other. My formula returns #INVALID OPERATION.

=COUNTIFS({Agent}, @cell = Name@row, {Offer Amount}, {Secured Amount})

The thing that confuses me is, even when i go to the referenced sheet and try to do a summary with =COUNTIFS({Offer Amount}, {Secured Amount}) or any variation thereof, even that doesn't work.

I have tried several different ways and looked on google for 20 minutes for an answer with no luck. Is this even possible?

Tags:

Answers

  • KPH
    KPH ✭✭✭✭✭✭
    Options

    How about adding a column to the referenced sheet with

    = [Offer Amount]@row - [Secured Amount]@row

    and counting the rows where that is 0?

    =COUNTIFS({Agent}, Name@row, {new column},0)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!