Good evening guys,

So this works if all the cells have data, but if blank, I get a #N/A error.

=SUMPRODUCT((H8:H11)*(L8:L11)*(G8:G11="SA450/60"))

As data will be added during the month the table starts off fairly sparse so I'd like my formula to skip/ignore if left blank.

Tried a few variants I've found online but no success.

Thanks in advance.