Trying To Find The Maximum Value

[Drip_Drip]

I'm using the following Array to pick up the maximum value of a range of cells. Currently it only looks at the cells S4:W60

=MAX(IF(Data!$B$4:$B$60=Analysis!$A12,Data!$S$4:$W$60,""))

I need to adapat it so that it picks up the maximum value between G4:K60, M4:Q60, S4:W60, Y4:AC60 and AE4:AI60.

Despite many attempts I'm unable to accomplish the task.

Any assistance would be appreciated.

 

[barry houdini]

Do you have anything in a header row which would distinguish columns to ignore, i.e. in the header for columns L, R, X etc.?

That would probably make for a simpler formula, otherwise try

=MAX(IF(data!$B$4:$B$60=analysis!$A12,IF(MOD(COLUMN(data!$G$4:$AI$60)-COLUMN(data!$G$4)+1,6)<>0,data!$G$4:$AI$60)))

confirmed with CTRL+SHIFT+ENTER