SUMIF - real simple problem... But does NOT work :-(

Does NOT work:

If I type:

=SUMIF(W3:W101,"< X2",V3:V101)

The cell 'X2' has a number (computed with a formula) - This above command does NOT work .

-------
But, if I type 69 instead of X2, like

=SUMIF(W3:W101,"< 69",V3:V101)

with a number inside the double quotes, it works perfectly fine. What should I do to make the CRITERIA accept a cell reference rather than a manually typed in number?

Thanks

Subbu

Change your formula to the following:

=SUMIF(W3:W101,CONCATENATE("< ",X2),V3:V101)

It should work.

Thanks a lot.

Subbu

Originally Posted by taylorm

Change your formula to the following:

=SUMIF(W3:W101,CONCATENATE("< ",X2),V3:V101)

It should work.

I looove this forum! Thanks, Taylor - this is exactly what I need to solve a similar problem.