Ask Your Question

Why doesn't SUMIF take cell data? [closed]

asked 2016-10-29 20:31:54 +0200

MrAdventure gravatar image

=SUMIFS('Tailoring Mats'.G:G, 'Tailoring Mats'.I:I,">K20")

Returns 0 when K20 has 375 in it, but

=SUMIFS('Tailoring Mats'.G:G, 'Tailoring Mats'.I:I,">375")

Returns the correct number.

I've tried this on a bunch of other rows and it appears that putting another cell in for the test always returns 0.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-14 15:21:47.890884

1 Answer

Sort by » oldest newest most voted

answered 2016-10-29 22:05:02 +0200

mark_t gravatar image

The way you wrote the function it checks that the cells have a string greater than the string "K20". You need to make it check for the value greater than the content of the cell K20.

=SUMIFS('Tailoring Mats'.G:G, 'Tailoring Mats'.I:I,">" & K20)
edit flag offensive delete link more

Question Tools

1 follower


Asked: 2016-10-29 20:31:54 +0200

Seen: 137 times

Last updated: Oct 29 '16