I have a screen shot of what I am trying to accomplish
Capture1.JPG
In Column F I want to sum up the maximum number of matches from Col B:E
irregardless if they are -1 or 1's
I am using Excel 2007
I have a screen shot of what I am trying to accomplish
Capture1.JPG
In Column F I want to sum up the maximum number of matches from Col B:E
irregardless if they are -1 or 1's
I am using Excel 2007
Would this work for you?
=MAX(COUNTIF(A1:D1,1),COUNTIF(A1:D1,-1))
Sincerely
S?ren Larsen
"Give a man a fish, and you'll feed him for a day. Give a man a fishing rod, and he'll steal your yacht!"
Try this formula in F3 copied down
=MAX(COUNTIF(B3:E3,{1,-1}))
If you want it to work with any values, rather than just 1 and -1 then try this version
=MAX(COUNTIF(B3:E3,B3:E3))
confirmed with CTRL+SHIFT+ENTER
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks