On Jan 7, 3:45*pm, Richhall wrote:
Thanks for your help, my formula is now this:

=SUM(IF('Sheet 1!$B$3:$B$499="Day",IF('Sheet 1'!$E$3:$E$499="App
A",'Sheet 1'!$L$3:$L$499,0),0))

The only problem is when I change "App A" to say a cell reference, as
it doesn't work then.

Cheers

Rich

Apologies "App A" is in fact "Service"