is it possible to sum the product of 2 or more cells, 1 cell being the result
of
a HLOOKUP function, without creating a third cell for individual results?
Here is my problem:
Row A contains a list of different locations
Row B contains wether the delivery has failed or completed
Row C contains the quantity of items on Invoice

Is there a formula I can use to have the total quantity from all of the
failed deliveries for that day?

As the failed delivery locations may vary from day to day, I cannot just
total those cells from each location

I have tried this formula, but it returns '#VALUE!':
=HLOOKUP("F",C4:L7,SUMIF(C4:L4,TRUE))

Any suggestions?