Hello from Steved

{=SUMPRODUCT(--('Depots by Bus Type'!$A$3:$A$30="B"),--('Depots by Bus
Type'!$I33="Roskill"),'Depots by Bus Type'!$B$3:$J$30)}

On worksheet to depots I've the above formula that id displaying #VALUE!
I've been going around in circles for over an hour.

Ok to sum from B3:J30 from Worksheet "Depots by Bus Type"

=SUMIF($B$34,"B",'Depots by Bus Type'!D7) this works, B34 = "Roskill"

What is required please.

Thankyou.