Hi

I am trying to write a SUMIF formula that will sum across a range of
worksheets in a workbook. I never know how many worksheets there will be in
this range. The formula I am trying is
=SUMIF(Clin1:ClinEND!K:K,NOTES!B8,Clin1:ClinEND!U: U).

Can anyone help? If this is not possible using a SUMIF, is there another
formula that would work?

Thanks

Mike