Ask Your Question
0

Why doesn't SUMIF take cell data?

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

=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
1

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

Question Tools

1 follower

Stats

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

Seen: 21 times

Last updated: Oct 29 '16