B BMD Board Regular Joined Oct 5, 2005 Messages 211 Nov 18, 2005 #1 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.
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 MrExcel MVP Joined Jul 21, 2002 Messages 73,092 Nov 18, 2005 #2 Maybe try: =SUMPRODUCT(--(INDIRECT("'"&C$1&"'!$G$3:$G"&C$8)="Pass"),(INDIRECT("'"&C$1&"'!$M$3:$M"&C$8)/60))
Maybe try: =SUMPRODUCT(--(INDIRECT("'"&C$1&"'!$G$3:$G"&C$8)="Pass"),(INDIRECT("'"&C$1&"'!$M$3:$M"&C$8)/60))
B BMD Board Regular Joined Oct 5, 2005 Messages 211 Nov 18, 2005 #3 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.
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.