Logical IF return a cell reference

  • Thread starter Thread starter Larry G
  • Start date Start date
L

Larry G

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.
 
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),"")
 
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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return a cell reference as a result of an IF formula 1
SUM for logical values 6
Excel formula, sum the value cell and if empty cell left blank 0
Summing rows using formulas with variables 1
Formula to return the reference of a range of cells 4
Logical statement for 'contains' ? 1
"IF" Function 1
empty cell as a result of IF formula 9

Back
Top