BrutalLogiC
Active Member
- Joined
- Feb 26, 2006
- Messages
- 267
- Office Version
- 2016
- Platform
- Windows
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
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