Max value using COUNTIF formula

Dishboy09

New Member
Needing some help to figure out this formula.

I am using COUNTIF currently of this =COUNTIFS(AF:AF,T6,AT:AT,">0") to find # of 0-1 values in columns. This certain part of my sheet uses a different setup. This particular one gives a certain # but on say half of the entries. I need a max value formula to search the same criteria in the countif but find the max value associated with T6 from AF:AF in AT:AT??

THANKS!

Dishboy09

New Member
All the ranges need to be the same size.

Well that made it click in my head! I believe I have it working now.

Thanks!

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Fluff

MrExcel MVP, Moderator
Glad we could help & thanks for the feedback.

Candyman8019

Board Regular
Give this a try, in this example, column A has the list of names and column B has the scores:
row 2: bob 50
row 3: bob 25
row 4: john 60
row 5: steve 70

=MAXIFS(\$B\$2:\$B\$5,\$A\$2:\$A\$5,A2)

Replies
12
Views
421
Replies
9
Views
176
Replies
0
Views
111
Replies
11
Views
166
Replies
6
Views
43

1,130,424
Messages
5,642,041
Members
417,251
Latest member
Dordrecht

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back