#VALUE! problem

BMD

Board Regular
Joined
Oct 5, 2005
Messages
211
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.
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Maybe try:

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

BMD

Board Regular
Joined
Oct 5, 2005
Messages
211
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,069
Messages
5,570,010
Members
412,304
Latest member
citrus
Top