man going bold pulling his hair out over this formlua

[richard hales]

Hi everyone
I have a formlua below which links to another work sheet,this formlua is leaving a 0 in my 2nd work sheet can this formlua be changed so it wont leave a 0. I've gone to options and hid the zero values but because the formlua in sheet reads the 0 it giving me a false reading can anyone help a man going bold pulling his hair out over this.

=IF(COUNTA(B21:B24),SUMPRODUCT(SUMIF('cmart code'!D2:D15,B21:B24,'cmart code'!E2:E15)),"")

 

[barry houdini]

Try

=IF(SUMPRODUCT(SUMIF('cmart code'!D2:D15,B21:B24,'cmart code'!E2:E15)),SUMPRODUCT(SUMIF('cmart code'!D2:D15,B21:B24,'cmart code'!E2:E15)),"")

 

[richard hales]

barry
what can i say but your great it works like a dream. Could you help me with another one please the formlua is =IF(AND('Wkly hours'!C16>=1,'Wkly hours'!C16<=14),"Employee1 ","") if it could be done instead of ''Employee1'' could the formlua include the head of the column and not ''Employee1''.