want to learn
New Member
- Joined
- Aug 25, 2007
- Messages
- 33
Hello All,
I hope you can help me with this.....
I am creating a speadsheet of material i approve for purchase and the cost assciated with it.
So, in column A i have the PO number, in column B i have the model number and in column C i have the unit cost and in column D i have the total cost for that order.
In cell $E$51, I want a formula to look at column B and see if it matches a criteria. If true, i want it to total the amounts of column D.
I hope you can help me with this.....
I am creating a speadsheet of material i approve for purchase and the cost assciated with it.
So, in column A i have the PO number, in column B i have the model number and in column C i have the unit cost and in column D i have the total cost for that order.
In cell $E$51, I want a formula to look at column B and see if it matches a criteria. If true, i want it to total the amounts of column D.