Ask Your Question

Why doesn't SUMIF take cell data?

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

=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 close merge delete

1 Answer

Sort by » oldest newest most voted

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

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
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 31 times

Last updated: Oct 29 '16