I have 3 columns of data on a spreadsheet. They are company name, a field with numbers and a cost field These numbers are not unique to the company. I would like a formula that states that if the company is X and the number corresponding is Y then add the corresponding cost.
Example
BT 4 £15
BT 3 £18
NTL 4 £22
BT 3 £11
So in this example I want the answer to be £29 as I wanted all BT records with status of 3.
Any help with this would be very appreciated.
Regards
Example
BT 4 £15
BT 3 £18
NTL 4 £22
BT 3 £11
So in this example I want the answer to be £29 as I wanted all BT records with status of 3.
Any help with this would be very appreciated.
Regards