I am trying to create a maxif statement without using an array. When I use this formula without an array =MAX(IF(AND($A$1:$A$5=A1, $B$1:$B$5=B1),($C$1:$C$5)) it works for the range of rows 1 to 5 but since I want to be able to drag this formula down and not redo it for each section and when rows are added I changed it to =MAX(IF(AND($A:$A=A1, $B:$B$B1),($C:$C)). After the change it no longer returns the correct values. Any ideas why or how to fix it without using an array?