sumif + indirect

[kevcar40]

hi
i am trying to sum a range using the formula below
AM1 is the number of rows
column BH reads the op number (has to be present)
column BM holds the time value

=SUMIF(INDIRECT("BH2:BH"&$AM$1),AT2,"BM2:BM"&$AM$1)
i cant get this to calculate

thanks


kevin

 

[Guest]

Try this amendment:
=SUMIF(INDIRECT("BH2:BH"&$AM$1),AT2,INDIRECT("BM2:BM"&$AM$1))
(you forgot the indirect around the BM range)

 

[kevcar40]

hi
i am trying to sum a range using the formula below
AM1 is the number of rows
column BH reads the op number (has to be present)
column BM holds the time value

=SUMIF(INDIRECT("BH2:BH"&$AM$1),AT2,"BM2:BM"&$AM$1)
i cant get this to calculate

thanks

kevin

thanks max

 

[Max]

Ah, no prob. You're welcome.