Excel Formula

[Pamsie]

Hi, i am looking for a formula for the attached spreadsheet in column S that will only add columns K through Q IF there is something in column Q

Perhaps it would be easier to only total column R IF there is something in column Q......

basically I don't want any average figure until column Q/month 6 has an entry in it. 

I just can't work it out!!!

Any help would be great, thank you :) 

[#2 · Accepted solution]

@Pamsie 

This formula will keep Cell S4 blank until something is in Q4.

=IF(Q4<>"", R4/7,"")

You'll probably want to do something similar in columns T through V, just to keep them blank until S has something in it.

I've generally found in my own sheets, that the  <>"" is a good way to say "not blank"    It could also be turned around, =IF(Q4="","", R4/7), which is then saying IF Q4 is blank, keep S4 blank; otherwise, divide R7 by 7.

[#3]

@Pamsie 

Perhaps you mean

=SUM(K4:Q4)*(Q4<>"")

in R4

[#4]

Oh Sergei, that has worked BEAUTIFULLY!!!!

thank you!

I didn't even think of 'not blank'  :) 

absolutely wonderful  @mathetes 

[#5]

@Pamsie , you are welcome