Hi all,
After some recent help from the forum I'm successfully using the following
array formulas to calculate the MAX values in several columns of cells. The
values used to calculate the MAX depend on other numerical values located in
adjacent columns:

{=IF(K1019="","",MAX(IF($G$3:$G$1002=$H$3:$H$1002, K3:K1002)))}

{=IF(P1019="","",MAX(IF($E$3:$E$1002=$F$3:$F$1002, IF($G$3:$G$1002=$H$3:$H$1002,P3:P1002))))}

{=IF(U1019="","",MAX(IF($G$3:$G$1002=0,IF($H$3:$H$ 1002=0,U3:U1002))))}

{=IF(AL1019="","",MAX(IF($G$3:$G$1002+$H$3:$H$1002 <3,AL3:AL1002)))}

{=IF(AK1019="","",MAX(IF(($G$3:$G$10023)+($H$3:$H $10023),AK3:AK1002)))}

I was hoping I could also calculate AVERAGE and MIN values using the same
basic formulas. However, I have cells within my data ranges which have 0
(zero) values (which I use) whilst other cells are unused (blank).

How can I rework my formulas to extract AVERAGE and MIN values whilst
ignoring the blank cells within my data ranges?

Cheers.