markdenovan
Board Regular
- Joined
- Dec 15, 2002
- Messages
- 97
Hi,
I have a formula which I think should work:
{=SUM(('Blue Cell Data'!$B$4:$B$108='A Shift'!D9)*('Blue Cell Data'!$C$4:$C$108="A")*('Blue Cell Data'!$I$4:$I$108))}
Blue Cell Data!$B$4:$B$108 = custom date dd/mm/yyyy
A Shift!D9 = a custom date dd/mm/yyyy
Blue Cell Data!$C$4:$C$108 = General Text
Blue Cell Data!$I$4:$I$108 = Number
It should work, the values are there to be picked up, but all I get is #value!
Any ideas?
Many thanks,
Mark
I have a formula which I think should work:
{=SUM(('Blue Cell Data'!$B$4:$B$108='A Shift'!D9)*('Blue Cell Data'!$C$4:$C$108="A")*('Blue Cell Data'!$I$4:$I$108))}
Blue Cell Data!$B$4:$B$108 = custom date dd/mm/yyyy
A Shift!D9 = a custom date dd/mm/yyyy
Blue Cell Data!$C$4:$C$108 = General Text
Blue Cell Data!$I$4:$I$108 = Number
It should work, the values are there to be picked up, but all I get is #value!
Any ideas?
Many thanks,
Mark