Help with sum formula

**wonderd** · 10-17-2018, 04:40 PM

Hey everyone I have a simple formula I'm having trouble getting to work.

Screenshot of the formula is here https://www.screencast.com/t/mp1lIes0hSlq

I only want to add cells with negative numbers if it has the word paypal or bkcd however its returning a 0 value

Correct output should be -4

**CK76** · 10-17-2018, 04:57 PM

You can't sum text values.

Are you able to split column using Text to Columns?

You would then be able to use SUMIF/SUMIF(S) on it.

Alternately... if only the negative value has string after it...
Try.

Formula:

Please Login or Register  to view this content.

Confirmed as array (CTRL + SHIFT + ENTER).

If there can be other text and positive numbers in the mix...

Formula:

Please Login or Register  to view this content.

Confirmed as array (CTRL + SHIFT + ENTER)

**wonderd** · 10-17-2018, 05:11 PM

This was the entered value https://www.screencast.com/t/Xj0K9IgNmEm , this was the result https://www.screencast.com/t/NDUoWdYH

**jeffreybrown** · 10-17-2018, 06:53 PM

Administrative Note:

We would love to continue to help you with your query, but first, before we can proceed…
Please see Forum Rule #3 about cross-posting and adjust accordingly...
Also see, A message to forum cross posters