adding empty cell only if nothing else is entered in referring cells

[ioneabee]

Hi

I need to enter an empty "total" cell (text) in a "total" tab if the other cells are empty, otherwise enter a dash "==="

refer to cell D29, D30 & D31 on the attached

I know this formula is incorrect but hopefully it gives you the gist of what I'm trying to do

=IF((Monday!I30)and(Tuesday!I30)and(Wednesday!I30)and(Thursday!I30)and(Friday!I30)="","","=====")

many thanks in anticipation

[JBeaucaire]

In D24, the corrected formula could be:

=IF(SUM(Monday:Friday!I24)=0, "", SUM(Monday:Friday!I24))

In D30:

=IF(SUM(Monday:Friday!I30)=0, "", "=====")


This 3D sum technique will require that you correct the cell fomatting, the Monday sheet cell I30 was formatted as text, so it didn't work until I got an actual number into that cell. Play around with it.

[ioneabee]

hi
thanks for the tip on D24 etc
unfortunately, D30 isn't coming out as i hoped - the "=====" isn't appearing in the total sheet where there is an actual figure in the monday sheet. what I'm doing is ignoring that time code in the total sheet ie not adding it up, but do want it to show that there has been data entered against it, but empty if there is no data
thanks again

[JBeaucaire]

what I'm doing is ignoring that time code in the total sheet ie not adding it up, but do want it to show that there has been data entered against it, but empty if there is no data

That's what my formula does as far as I can tell.