Help with countif, I think...

[pvautour_4242]

I'm working on a sale and call tracker for the contact center where
work. Calls come in on certain queues. I have my spreadsheet set up s
that when a call comes in I enter the queue number in, then the cal
details, sale made, etc.

My question is this. I am wanting to count the number of sales pe
queue that are made. I have a feeling that it should be a "countif
formula, but am having no luck. I have included an example of what th
tracker looks like and the rows that I am trying to count below.

Queue | Name | Call details | Sale y/n | order number | Total
1 Ted printer Y 123456789
599.99
4 Kathy cartridge N 123456780
3 George Pen Y 123456781 4.95


So what I'm trying to do is count the times that I made a sale in queu
1, 2, 3, or 4. I've got cells ready to take the information down, jus
can't, for the life of me, figure out the correct formula. :confused

 

[Mallycat]

It sounds like a job for a pivot table. You can do lots more than just
total up the sales for one queue.

Matt

 

[bobocat]

I suppose that you want to count the number of sale appeared in the column
D, am I correct?
the formula should be:
=countif(d2:dX, "Y")

 

[pvautour_4242]

-I suppose that you want to count the number of sale appeared in
the column
D, am I correct?-

Not quite...Let's try it this way. In column "a" I am adding the
queues, in column "b" I am adding y/n for whether or not there was a
sale made. I am obviously able to count the number of calls that have
come in on a particular queue using "=COUNTIF(a1:a60,"110")", but now I
want to know how many times a sale has been made in that queue. I've
tried a few different formulas, such as
"sumproduct((a1:a60="110")*(b1:b60="y"))", however this is not
returning any results. I have yet to attempt a pivot table, which was
also suggested to me. I'm hoping that someone will be able to help me
out with a formula before I get into pivot tables.

Thanks

 

[Bobocat]

IC, have you try
=sumproduct((a1:a60=110)*(b1:b60="y"))

Moreover, in Excel 2007, =countifs can help

"pvautour_4242" <[email protected]>
wrote in message
news[email protected]...