Hi All,
Hoping someone can help with my ignorance. I've got a sumproduct formula that's giving me issues.
Currently the formula is:
I'd like to update to:![]()
=SUMPRODUCT(--('2012 Schedule'!$B$2:$JC$2<=$A2),'2012 Schedule'!$B$3:$JC$3)
But, this gives me the #VALUE error and not sure how to fix.![]()
=SUMPRODUCT(--('2012 Schedule'!$B$2:$JC$2<=$A2),INDIRECT("'2012 Schedule'!$B$"&COLUMN(C1)&":$JC$"&COLUMN(C1)))
Any help is greatly appreciated.
Thanks,
Cullen
Bookmarks