# man going bold pulling his hair out over this formlua

#### richard hales

##### Board Regular
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)),"")

### Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
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)),"")

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''.

1,207,091
Messages
6,076,522
Members
446,211
Latest member
b306750

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back