Sumit

[Joel]

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]

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

Regards,
Fred

 

[Peo Sjoblom]

Use

A1:A10,"<"&B10,

when you test for cell contents

--


Regards,


Peo Sjoblom

 

[Joel]

Thank you so much!
Joel

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

Regards,
Fred



.

 

[Joel]

Peo:

Thanks so much!
Joel

Use

A1:A10,"<"&B10,

when you test for cell contents

--


Regards,


Peo Sjoblom





.