SUMIF Issue

[francoiscj1]

I have the following formula:

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=SUM(SUMIFS(F7:F9,E7:E9,{"*Exhibit*","*Exhibits*"},I8:I10,"No"))

I would like to modify this formula so that the formula will sum the different variations of Exhibit (e.g., Exhibit, Exhibits, and Exhibit A) in my worksheet.
[/FONT]

 

[Fluff]

How about
=SUMIFS(F7:F9,E7:E9,"*Exhibit*",I7:I9,"No")