ExcelBanter - Sumit

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Sumit (https://www.excelbanter.com/excel-worksheet-functions/249069-sumit.html)

joel

Sumit

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[_4_]

Sumit

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

Regards,
Fred

"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

Peo Sjoblom[_3_]

Sumit

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

joel

Sumit

Thank you so much!
Joel

"Fred Smith" wrote:

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

Regards,
Fred

"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

.

joel

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

.

All times are GMT +1. The time now is 10:34 PM.