I have a Workbook with worksheets labeled for each working day which has
entries for different locations and quantities deliveries and I need to
calculate how many failed deliveries there were and how many lates - layout
of the sheet would help

drop1 drop3 drop4 drop5 Failed Late
FAIL/LATE f l l 1 2
type 1 25 6 10 20 25 30
type 2 92 81 60 40 92 100
type 3 163 465 15 25 163 40

This sheet is completed every day, then at the end of the week I need a
tally of all failed and all late drops and the quantities. I have tried
using LOOKUP, IF, FREQUENCY, COUNTA, COUNTIF and still cannot get the thing
to work.

Does anyone -
A - Understand what I am going on about, because I think i've confused myself!
B - Have some idea on how to get the result I need

Any help would be apreciated!