SUMIFS not working with a negative value

[Gijs]

I’m using formula =SUMIFS (sum_range, range1, criteria1)
In specific =SUMIFS($F$5:$F$57,$K$5:$K$57,">0"), which works fine when the values in range1 $K$5:$K$57 are all positive. With negative values in range1 $K$5:$K$57 and matching negative values in the sum_range $F$5:$F$57, it evidently doesn't provide the correct outcome with a negative value in range1 ">0". (All cells in sum_range, range1 are numbers).

I’ve tried, all to no avail:
=SUMIFS($F$5:$F$57,$K$5:$K$57,"<>0")
=SUMIFS($F$5:$F$57,$K$5:$K$57,"*")
=SUMIFS($F$5:$F$57,$K$5:$K$57,">0",$K$5:$K$57,"<0")

How do I redefine criteria1 “>0” to ensure the SUMIFS includes a negative value in sum_range and range1?

Can anyone help me?
Gijs

[Indi_Ra]

For me it work =SUMIFS($F$5:$F$57,$K$5:$K$57,">0").
Upload a workbook .

Try =SUMIFS($F$5:$F$57,$K$5:$K$57,"<>")

[etaf]

>0
means greater than zero
so will not sum negative values

=SUMIFS($F$5:$F$57,$K$5:$K$57,">0",$K$5:$K$57,"<0")
is saying the values are less than 0 AND greater than zero

=SUMIF($K$5:$K$57,"<>0",$F$5:$F$57)
should work - but will also sum blank cells

Also to avoid any blank cells being included
=SUMIFS($F$5:$F$57,$K$5:$K$57,"<>",$K$5:$K$57,"<>0")

i assume you do not want to include zero

[Gijs]

WONDERFUL! Works like a charm, thank you Indi_Ra

have a great rest of the weekend!

[Gijs]

Greatly appreciated etaf! Thank you for the various solutions and education.

Have a great rest of the weekend,
Gijs

[Gijs]

Greatly appreciated etaf! Thank you for the various solutions and education.

Have a great rest of the weekend,
Gijs

[RLONG98]

Hello,
Leila has a video on 'sumifs' between dates
youtube.com/watch?v=XIhbL20jTHc&t=426s

I have the same type of sheet i'm testing on - with NEGATIVE numbers, and it returns 0

So if you had her exact sheet - how would the formula look?

Thank you

[jeffreybrown]

Administrative Note:

Hi RLONG98 & Welcome to the forum.

We are happy to help, however; while you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

[RLONG98]

OK Jeff,
Thank you -
I didn't think it was 'hijacking' - but rather furthering a conversation, so I didn't want to inundate searches on SUMIFS and have to many come up.

I'll post new
Thank you