Excel: Count query

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.

For more resources for Microsoft Excel