IF then ????

[authorsami]

I have a spreadsheet that looks like the following:

Shipments 1 2 1
prod1 125 50 52
prod2 85 25 10

can I put a formula in to tell me if the shipment is #1 then to add the 125 and the 52. Keep in mind I will have many rows of 1,2,3,etc......I know this is a if then, but not sure exactly how to do this.

If you need to see the actual spreadsheet please let me know I can email to your directly.

Sharon

 

[TonyJollans]

Hi Sharon,

For your example, with data is in B13, use ..

=SUMIF(B1:D1,1,B2:D2)

Enjoy,
Tony

------------------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading FAQ222-2244 before you ask a question.

 

[authorsami]

Oh my Gosh!!!!! That was so simple why oh why didn't I think of it... I was so close.

Thank you so much,Tony. This is just what I needed,

Sharon