Okay, here's the deal.
I have two columns with values. Then I have a third column with one letter A or B.
I'm not used to excel, but I've tried my way with COUNTIFS and I'm pretty sure it's the way to go, but I'm lost in the syntax.
I want to count the number of times the values in the first column is larger than the values in the second column, if the letter is A. And then flip the ">" sign and count that and hopefully the first number is higher.
I really hope you can help.
You can't use COUNTIFS - try SUMPRODUCT like this
=SUMPRODUCT((A2:A100>B2:B100)*(C2:C100="A"))
that will count rows where col A > col B and also col C = "A" - adjust rows as required
Audere est facere
That didn't seem to work. I get #VALUE!.
Did you use exactly that formula? - see attached example - formula in E2 highlighted
My bad, it works now. Thank you very much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks