Excel Formula

[luis.carrion]

I have a tab called slide and another tab called inventory. What I need is a formula that if column G1:G700 has a price and column I1:I700 has the words “KAF” sum it in the tab Called Slide on column B12.

 

[Richard Schollar]

Hi

That sounds like a SUMIF would work:

=SUMIF(Inventory!I1:I700,"KAF",Inventory!G1:G700)

 

[luis.carrion]

Not working

 

[luis.carrion]

I want column G2:G700 to sum if I2:I700 eguals kaf

 

[Dannyh1]

does work - you're doing it wrong

 

[luis.carrion]

am using excel 2007

 

[luis.carrion]

it gives me and error : #name?

 

[Richard Schollar]

Can you copy your formula as it appears in the address bar into your reply - you shouldn't be getting a #NAME? error. Are you using an English language version of Excel?

 

[villy]

excerp from Richard:
=SUMIF(Inventory!I1:I700,"KAF",Inventory!G1:G700)
change it to
=SUMIF(Inventory!I2:I700,"KAF",Inventory!G2:G700)
considering you have a headers
<!-- / message --><!-- sig -->

 

[luis.carrion]

It was missing the ' in front and after the tab name

Thank you