| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 . |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
