Mike,

You can create an OR condition in SUMPRODUCT with +

=SUMPRODUCT(((weeks<=current)*(weekscurrent-26))+((weekscurrent+26)*(weeks
current)),B6:B57)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Mikeopolo" wrote
in message ...

Hi James

Sorry about that, I didn't notice in later testing.

The sumproduct conditions are additive, ie only AND.

You need something slightly different.

Try pasting this formula into C6, then copy/paste in C7 thru C57:

=IF(OR(AND(A6(current-26),A6<=current),A6(current+26)),B6,0)

Then in E1 sum this range of cells.

Not as elegant as the single cell formula, but correct; of course it
assumes that this range is available.

I was using this method to cross-check my sumproduct formula.

Regards
Mike


--
Mikeopolo
------------------------------------------------------------------------
Mikeopolo's Profile:
http://www.excelforum.com/member.php...o&userid=18570
View this thread: http://www.excelforum.com/showthread...hreadid=503604