Hi,
I am working on a document that has a list of supplier names of companies delivering in, in column A (Suppliers may appear multiple times). Arrival times are in column B ("Late" or "on time"). On a separate worksheet I need to be able to record how many times each supplier was either late or on time.
I have been playing around with countif but struggled due to the multiple criteria. I have also tried Sumproduct etc but still have no joy.
Does anybody have any ideas.
I hope you can help
Kind Regards
Alan
I am working on a document that has a list of supplier names of companies delivering in, in column A (Suppliers may appear multiple times). Arrival times are in column B ("Late" or "on time"). On a separate worksheet I need to be able to record how many times each supplier was either late or on time.
I have been playing around with countif but struggled due to the multiple criteria. I have also tried Sumproduct etc but still have no joy.
Does anybody have any ideas.
I hope you can help
Kind Regards
Alan