Excel totalling help

[peterattheboro]

Hello there.

I am having some chew figuring this out.

I'll try and explain as easily as possible.

I have a list with 10 people. We have an option in the sheet where people make enquiries. That total is added fine.

But some of those queries may have been accepted so I also need to add an option for that and a sum which will could the accepted ones per person.

How is this done?

So for example:

I have a combo box with the cell link $W$4 which when the person is selected, inserts a number of 2, 3, 4, 5 etc into that box.

I need a sum which will count that number IF cell $X$4 has a 2 in it.

I'm sure this will be easy for some of the excel wizards here.

Thanks in advance.

 

[peterattheboro]

Actually I kinda think I know what I need. So we have all the months of 2009 and a summary page.

On the summary page there are the columns:

Quotes / Accepted

In the Accepted column for January I need something like =SUM(IF)Y4=2 (+ IF W4 = 2,3,4 etc) (Where 2,3,4 is which person has been selected)

What is the correct layout for that?

 

[SimonCHere]

Hello there.

I am having some chew figuring this out.

I'll try and explain as easily as possible.

I have a list with 10 people. We have an option in the sheet where people make enquiries. That total is added fine.

But some of those queries may have been accepted so I also need to add an option for that and a sum which will could the accepted ones per person.

How is this done?

So for example:

I have a combo box with the cell link $W$4 which when the person is selected, inserts a number of 2, 3, 4, 5 etc into that box.

I need a sum which will count that number IF cell $X$4 has a 2 in it.

I'm sure this will be easy for some of the excel wizards here.

Thanks in advance.

Something like

=SUMIF(X:X,2,W:W)