Looking for formula correction

[wonderd]

Hello the below is a sum formula and adds number less the 0 and if other column matches the word "TEST"

=SUM(SUMIFS(E2:E308,E2:E308,"<0",F2:F308,{"TEST"}))


How do I make the formula still work if the other cell contains the word TEST along with other words? Does not have to be only the word TEST

[AliGW]

It depends. Where in the cell will the word be? Always at the start?

If so, then this:

=SUMIFS(E2:E308,E2:E308,"<0",F2:F308,"TEST"&"*")

This is superfluous to requirement as you have only one text value and you don't need the {}:

=SUM(SUMIFS(E2:E308,E2:E308,"<0",F2:F308,{"TEST"}))

could easily be:

=SUMIFS(E2:E308,E2:E308,"<0",F2:F308,"TEST")

[wonderd]

Thanks. I was able to get it to work with your help. Solved.

[FDibbins]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

[FDibbins]

You are still required to provide the link to your x-posting.