Cell contails specific text

[blossomthe2nd]

=IF(E38="Blue",(SUMIFS(F38:X38, F39:X39, "")), "0")

Hi all

I use the above formula to sum row 38 when the row belows cell are blank , can I change that condition to ONLY sum if cell DOES NOT contain a * ?

Is that possible with this formula?

Thanks
A

 

[FormR]

Hi, you could try like this:

=IF(E38="Blue",SUMIFS(F38:X38, F39:X39, "<>*~**"), 0)

 

[blossomthe2nd]

Hi, you could try like this:

=IF(E38="Blue",SUMIFS(F38:X38, F39:X39, "<>*~**"), 0)

Perfect works
thanks so much