Sumit
Peo:
Thanks so much!
Joel
"Peo Sjoblom" wrote:
Use
A1:A10,"<"&B10,
when you test for cell contents
--
Regards,
Peo Sjoblom
"Joel" wrote in message
...
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
.
|