COUNT MATCHING VALUES FROM TWO DIFFERENT COLUMNS ON A SEPERATE SHEET

PinnCason

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?

KPH

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)