Sumit
(1)

Sumit

Asked By Joel

20-Nov-09 06:21 PM

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

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

Fred Smith replied to Joel

20-Nov-09 06:24 PM

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

Regards,
Fred

UseA1:A10,"<"&B10,when you test for cell contents--Regards,Peo Sjoblom

Peo Sjoblom replied to Joel

20-Nov-09 06:27 PM

Use

A1:A10,"<"&B10,

when you test for cell contents

--


Regards,


Peo Sjoblom

Thank you so much!Joel"Fred Smith" wrote:

Joel replied to Fred Smith

21-Nov-09 09:32 AM

Thank you so much!
Joel

Peo:Thanks so much!Joel"Peo Sjoblom" wrote:

Joel replied to Peo Sjoblom

21-Nov-09 09:33 AM

Peo:

Thanks so much!
Joel

Previous Discussion: IF calculation