Help[ with a formula

[want to learn]

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.

 

[Mike Blackman]

Hi,

How about;

=SUMIF(B1:B50,"Random Material",D1:D50)

 

[want to learn]

Re: Help with a formula

Thanks,
That was simple. I am a little embarrassed.