I am trying to get the numerical values of three different cells on three different worksheets to sum at a single cell on a fourther worksheet.

my formula is

='Weekly CM Workorder Count'!B6+'Weekly DIS Workorder Count'!B6+'Weekly PM Workorder Count'!B6

However I am finding that the sum ends up being zero!

I understand this may be due to some array formula or something like that however i am a bit grey in this area.

I have tried to use crt+shift+enter as suggested on a thread i found in my search however no avail.

I eventually hope to drag the target cell down so I get a groups of sums going down my column.

I would appreciate if someone could advise why i am getting zero's

Thankyou