Excel Help

[Masked Revenger]

So, I need the help of an Guru is happens to be a ... well, guru with Excel.

Here's the situation. I got a spreadsheet with three columns.

Column A is numbers of orders. Column B is the names of vendors, and Column C has either New Customer or Returning Customer in it.

Now, what I need to do is find a formula that will total the number of orders for New Customers for a particular Vendor.

Anyone know how to do that?

Chris

[Cryogentic]

press = in a section and it should give you a place to enter a formula

[Masked Revenger]

press = in a section and it should give you a place to enter a formula

Yesssss.....

What I'm asking here is what formula to use. I'm pretty sure it's going to requre nesting, but I cannot figure out what formula will work for this question.

Looking for help with that.

Chris

[Cryogentic]

I don't have time to figuer it out leaving class :/ if you still don't have any help by the time i get to a computer again I'll see what I can do but it sounds like an if and then statement

[PawnOfFate]

Masked, do you have AIM? I can help you out, but I'd need to talk through it in steps.

[Masked Revenger]

Masked, do you have AIM? I can help you out, but I'd need to talk through it in steps.

I do, I just logged in, Masked Revenger9.

Chris

[Masked Revenger]

Faith, thanks for all the help! I'll post here tomorrow to let you know if it works.

Chris

[PawnOfFate]

No problem. I actually had fun trying to figure it out. :) Faith... hmm. Never been called that ;)

[coldcut]

No problem. I actually had fun trying to figure it out. :) Faith... hmm. Never been called that ;)

It's Masked Revenger's latent George Michael fandom emerging.

What he really meant to say was,

Well I Guess It Would Be Nice
If i could touch your body
I know not everybody
Has got a body like you

But i've got to chink twice
Before i give my heart away
And i know all the games you play
Because i play them too

Oh but i
Need some rime off from that emotion
Time to pick my heart up off the floor
And when that love comes down
Without devotion
Well it takes a strong man baby
But i'm showing you the door

'Cause i gorra have faith....

Baby
I know you're asking me to stay
Say please, please, please, don't go away
You say i'm giving you the blues
Maybe
You mean every word you say
Can't help but think of yesterday
And another who tied me down to loverhoy rules-

Before this river
Becomes an ocean
Before you throw my heart back on the floor
Oh baby i reconsider
My foolish notion
Well i need someone to hold me
But i'll wait for something more

Yes i've got to have faith....

(Yes I had to look that up.)

[UnSub]

There's a countif formula that counts under an if condition.

Or perhaps you could do nested if statements. But all that's pretty academic without looking at the sheet itself.

[PawnOfFate]

i came up with a formula =sumif(<range>,"vendor 1",<cells>)-sumif(<range>,"Repeat Customer",<cells>)

It seemed to work just fine.

[Dr Jack Wolfe]

The Pivot table function under the DATA menu should have a wizard that will walk you thru it without getting tricky. It creates a new table that can added to the current sheet or on another sheet on the workbook.

[PawnOfFate]

So. Did it work?