Sumit

Joel · Nov 20, 2009

TIA:

Trying to do this:

=sumif(A1:A10,"<B10",A1:A10) but "<B10" is taken literally, not as a value
of B10.

Anyway to set criteria as cell reference such as <B10 ??

Thanks,
Joel

Fred Smith · Nov 20, 2009

Do it this way:
=sumif(A1:A10,"<"&B10,A1:A10)

Regards,
Fred

Peo Sjoblom · Nov 20, 2009

Use

A1:A10,"<"&B10,

when you test for cell contents

--

Regards,

Peo Sjoblom

Joel · Nov 21, 2009

Thank you so much!
Joel

Fred Smith said:
Do it this way:
=sumif(A1:A10,"<"&B10,A1:A10)

Regards,
Fred

.

Joel · Nov 21, 2009

Peo:

Thanks so much!
Joel

Peo Sjoblom said:
Use

A1:A10,"<"&B10,

when you test for cell contents

--

Regards,

Peo Sjoblom

.