#VALUE! problem

[BMD]

I'm getting a #VALUE! problem with :

=SUMPRODUCT(INDIRECT("'"&C$1&"'!$G$3:$G"&C$8)="Pass",(SUM(INDIRECT("'"&C$1&"'!$M$3:$M"&C$8))/60))

I'm trying to add all the time in column M if column G says it passed.

 

[Andrew Poulsom]

Maybe try:

=SUMPRODUCT(--(INDIRECT("'"&C$1&"'!$G$3:$G"&C$8)="Pass"),(INDIRECT("'"&C$1&"'!$M$3:$M"&C$8)/60))

 

[BMD]

Thanks, but it does not make sense. No where did I tell it to add column M. BUT IT WORKS.

I'm also messing around with a marco that I may also post. It's not working.

Thanks, Again,
Bruce.