Hi there I want to count the number of purchase orders that total more than £1,000 Column A is the list of purchase orders Column B is the description Column C is the cost The problem for me is for each purchase order there might be more than one line item, e.g. PO999, description = 2 hours labour, cost = £800 PO999, description = 10 widgets, cost = £500 So overall PO 999 is more than £1,000 so I can't just count the number of values over £1,000 in column C as it is not clever enough to take into account multiple rows. Help please with a formula that can handle this. Hope that's clear! Thanks
This question generated 21 answers. To proceed to the answers, click here.
This thread is current as of March 26, 2014.