Ooops! I missed the L6 criteria...but, that could just be prepended to my
posted formula (Assuming L6="x" applies to ALL situations)

Possibly this:
=(L6="x")*I6*J6*IF(K6<=C27,1,SUMPRODUCT((K6=B28:B 31)*(K6<=C28:C31)*D28:D31))

or...this
=IF(L6="x",I6*J6*IF(K6<=C27,1,SUMPRODUCT((K6=B28: B31)*(K6<=C28:C31)*D28:D31)),"na")


Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Ron Coderre" wrote:

First, you've got an ambiguity in your criteria.....

I understand the first part:
K6 AND
IS K6 THEN
<=C27 (N/A) I6*J6* D27
=B28 <=C28 I6*J6* D28
=B29 <=C29 I6*J6* D29
=B30 <=C30 I6*J6* D30
=B31 <=C31 I6*J6* D31

But the last one
=B30 (N/A) I6*J6* D32
conflicts with this (from above)
=B30 <=C30 I6*J6* D30

So.....ignoring the last criteria,
Try this:
=I6*J6*IF(K6<=C27,1,SUMPRODUCT((K6=B28:B31)*(K6<= C28:C31)*D28:D31))

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Shannon" wrote:

Sorry posted before I actually asked my question... this is how frazzled this
formula has me. I can see the logic but I cant figure out how to actually
write this formula out. Any suggestions would be greatly appreciated!

Thanks!
Shannon