if sum formula

[mikeywhits]

Hi Guys,

I am trying to do the following if formula where if false it will add the contents of cells R49, S49 & T49 together, though instead it is returning R49&S49&T49. Is it possible to do this?

=IF(L49=100%," CRT","SUM(R49&S49&T49)")

Thanks in advance,

Mike

 

[VoG]

Try

=IF(L49=100%," CRT",SUM(R49:T49))

 

[mikeywhits]

Hi Vog,

This returns "Value", which the formula is true, but it does not add the contents of the cells R49&S49&T49. The contents of the cell are letters if it helps

 

[VoG]

In that case

=IF(L49=100%," CRT",R49&S49&T49))

 

[mikeywhits]

Brilliant Vog, Thanks alot

 

[mikeywhits]

Hi Vog,

The formula gives the right outcome - CRT when 100%

=IF(L4=100%," CRT",R4&S4&T4)

Though the CRT is not recognised in other formulas e.g.

=SUMPRODUCT(--(X3:X26="Open"),--ISNUMBER(MATCH(Q3:Q26,{"R","A","G","CRT"},0)),M3:M26)

It adds all values which match these criteria except for CRT.

Any ideas?

Thanks

 

[VoG]

You need to delete the leading space in " CRT"

=IF(L4=100%,"CRT",R4&S4&T4)

 

[mikeywhits]

hahaha, yeah that works, thanks again