View Single Post
 
Old 10-21-2014, 08:04 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

I don't know how, but it looks like a parenthesis was moved.

Your sheet's formula starts as:
=IFERROR((SUMPRODUCT(A$8:A$182>=A2)...

That second parenthesis before SUMPRODUCT should be after it:
=IFERROR(SUMPRODUCT((A$8:A$182>=A2)...

Just copy the equation from the post a few above again and paste it again. There is an extraneous space that this forum put in one of the DATE's. I tried to get rid of it, but it keeps appearing.

Probably just better to move the parenthesis.
Reply With Quote