I'm doing a SUMIFS function and one of the criteria I want to set down is that I don't want to include any cells in a column that contain the word "storage" (e.g., "used as storage", "storage space", "storage").

My formula so far looks like this...

=SUMIFS($E:$E,$G:$G,"=",$C:$C,"<>"&"VACANT",A:A,"<>"&"Total Current"

then if in column C I didn't want any cells that included the word "storage" I would put into my equation.... --> ($C:$C, "<>"&"*storage*")

Correct? Or do I only need one asterisk?

Kind of nitpicky, but any help would be greatly appreciated.