paige wrote...
thanks...but how do i incorporate the if part of my formula? essentially, i
only need it to sum only when a condition is met.....do a sumproduct with a
match statement?

thoughts?
....

Reread what Dave told you to do. MATCH isn't needed.

SUMIF won't function if either its 1st or 3rd arguments are external
link references into closed workbooks. You can replace function calls
like

SUMIF(extref1,X,extref2)

with SUMPRODUCT calls like

SUMPRODUCT(--(extref1=X),extref2)

Replace the SUM(IF(..)) part of your formula with a SUMIF,

SUMIF($F$5:$F$92,$F280,O$5:O$92)

and replace the SUMIF part with SUMPRODUCT, at which point it wouldn't
need to be entered as an array formula.