| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Logical IF return a cell reference
I want to use a logical IF formula to return a cell range SUM, or at least a
cell reference. Can't seem to figure it out. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Logical IF return a cell reference
It is always better to post the formula you tried explaining how the data is
arranged. 'The below formula returns the value from cell B1 if A1 = 1 or otherwise returns blank =IF(A1=1,B1,"") The below formula will return the sum of cells B1:B10 if there is a text "Yes" in cell A1; or otherwise returns blank =IF(A1="YES",SUM(B1:B10),"") -- Jacob "Larry G" wrote: I want to use a logical IF formula to return a cell range SUM, or at least a cell reference. Can't seem to figure it out. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Logical IF return a cell reference
Say we want to sum B1 thru B100 if A1 is a one, otherwise sum C1 thru C100:
=SUM(IF(A1=1,B1:B100,C1:C100)) -- Gary''s Student - gsnu200909 "Larry G" wrote: I want to use a logical IF formula to return a cell range SUM, or at least a cell reference. Can't seem to figure it out. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return result of IF logical test in a different cell | Excel Worksheet Functions | |||
| Return cell reference rather than value | Excel Discussion (Misc queries) | |||
| Check if text exists within a cell range and return logical vaule - possible? | Excel Discussion (Misc queries) | |||
| Return cell reference instead of value | Excel Discussion (Misc queries) | |||
| Return value in cell above the reference | Excel Discussion (Misc queries) | |||
Hybrid Mode
