Sumif based on cell format or last cell in column (1 Viewer)

[qafself]

I have a column in which one cell will conditonally format to red if certain conditions are met.

I wish to take the value of this cell to another cell.

I thought that I could use SUMIF based on the colour to achieve the outcome but I don't know how to do this without coding in vba and I haven't got into vba yet.

Alternatively, this could be approached from a different angle which is that this cell will always be the last cell in the column with a calculated value in it - is there a way to select this?

Grateful for the benefit of your accumulated wisdom.

Ed

 

[shades]

If it is a numeric value and the last int he column, then this will give the cell address (assuming column B):

=ADDRESS(MATCH(9.99999999999999E+307,B:B),1)
________
X-90

 

[qafself]

Thanks for that Shades.

your solution gave me the address and then I had the problem of converting that to an actual cell value which I achieved eventually by using INDIRECT in front of it - problem solved.

Thanks again.

Ed

 

[shades]

Great. The other way to do it is to use INDEX instead of ADDRESS, which will give the value.
________
CHRYSLER NATRIUM SPECIFICATIONS