Need to add range reference to existing formulas

  • Thread starter Thread starter jsjenn
  • Start date Start date
J

jsjenn

I have two formulas I need to add range references to.

An Array {=SUM(IF(H7:H42=R53,P7:P42))}

A Formula
=IF(ISERROR(MATCH(R53,H7:H42,0)),"",INDEX(G7:G42,MATCH(R53,H7:H42,0)))

In the first, I need the ranges to be H7:H42 and AQ7:AQ45,
P7:P42 and AY7:AY45.

In the second, I need the ranges to be H7:H42 and AQ7:AQ45,
G7:G42 and AP7:AP4

Any help would be appreciated, JSJenn
 
Ranges in arrays have to be the same number of cells. 7 to 42 AND 7 TO 45
do not meet this critiera.
 
Back
Top