Below is the table i'm working with
However i've look at the previous link fro countif function's and wasnt sure
how i could implememnt that for wat i need.

10% Custom $50,023.00 $50,023.00 $50,023.00
14% Key $110,353.00 $112,000.00 $112,300.00
5% Custom $48,201.00 $110,353.00 $95,820.00
14% Key $112,000.00 $23,340.00 $72,000.00

What i have to do is: use a countif function to count all discounts (being %
column). note the discounts have to be for the quarter. not yearly.....
Thankyou for any help

--
Enquirer

Hi,

From the table below what answer do you expect to get?

Mike

"pejy69" wrote:

Below is the table i'm working with
However i've look at the previous link fro countif function's and wasnt sure
how i could implememnt that for wat i need.

10% Custom $50,023.00 $50,023.00 $50,023.00
14% Key $110,353.00 $112,000.00 $112,300.00
5% Custom $48,201.00 $110,353.00 $95,820.00
14% Key $112,000.00 $23,340.00 $72,000.00

What i have to do is: use a countif function to count all discounts (being %
column). note the discounts have to be for the quarter. not yearly.....
Thankyou for any help

--
Enquirer

Custom and key discounts for the Quarter. i presume the quarter being april,
may & June
--
Enquirer


"Mike H" wrote:

Hi,

From the table below what answer do you expect to get?

Mike

"pejy69" wrote:

Below is the table i'm working with
However i've look at the previous link fro countif function's and wasnt sure
how i could implememnt that for wat i need.

10% Custom $50,023.00 $50,023.00 $50,023.00
14% Key $110,353.00 $112,000.00 $112,300.00
5% Custom $48,201.00 $110,353.00 $95,820.00
14% Key $112,000.00 $23,340.00 $72,000.00

What i have to do is: use a countif function to count all discounts (being %
column). note the discounts have to be for the quarter. not yearly.....
Thankyou for any help

--
Enquirer

Give an example of what you expect in terms of that data, your explanation
explains nothing (to me at least).

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"pejy69" wrote in message
...
Custom and key discounts for the Quarter. i presume the quarter being
april,
may & June
--
Enquirer


"Mike H" wrote:

Hi,

From the table below what answer do you expect to get?

Mike

"pejy69" wrote:

Below is the table i'm working with
However i've look at the previous link fro countif function's and wasnt
sure
how i could implememnt that for wat i need.

10% Custom $50,023.00 $50,023.00 $50,023.00
14% Key $110,353.00 $112,000.00 $112,300.00
5% Custom $48,201.00 $110,353.00 $95,820.00
14% Key $112,000.00 $23,340.00 $72,000.00

What i have to do is: use a countif function to count all discounts
(being %
column). note the discounts have to be for the quarter. not yearly.....
Thankyou for any help

--
Enquirer

Sorry all
The details i have in front of me a
Use a countif function to count all discounts.
I belive i have to get the discount of 50,023.00 + 50,023.00 + 50,023.00 *
10% for te custom quarter. Then apply the same sort of thing to the 14% key
discount and so on.... i dont know how else to explain it, i hope that has
helped as i really need help....... if not i'm sorry, i dont really know what
else to add.

--
Enquirer


"Bob Phillips" wrote:

Give an example of what you expect in terms of that data, your explanation
explains nothing (to me at least).

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"pejy69" wrote in message
...
Custom and key discounts for the Quarter. i presume the quarter being
april,
may & June
--
Enquirer


"Mike H" wrote:

Hi,

From the table below what answer do you expect to get?

Mike

"pejy69" wrote:

Below is the table i'm working with
However i've look at the previous link fro countif function's and wasnt
sure
how i could implememnt that for wat i need.

10% Custom $50,023.00 $50,023.00 $50,023.00
14% Key $110,353.00 $112,000.00 $112,300.00
5% Custom $48,201.00 $110,353.00 $95,820.00
14% Key $112,000.00 $23,340.00 $72,000.00

What i have to do is: use a countif function to count all discounts
(being %
column). note the discounts have to be for the quarter. not yearly.....
Thankyou for any help

--
Enquirer

I'm still confused but taking you literally to work out the discount doesn't
require Sumif. Try this and drag down

=SUM(C1:E1)*A1

Mike


"pejy69" wrote:

Sorry all
The details i have in front of me a
Use a countif function to count all discounts.
I belive i have to get the discount of 50,023.00 + 50,023.00 + 50,023.00 *
10% for te custom quarter. Then apply the same sort of thing to the 14% key
discount and so on.... i dont know how else to explain it, i hope that has
helped as i really need help....... if not i'm sorry, i dont really know what
else to add.

--
Enquirer


"Bob Phillips" wrote:

Give an example of what you expect in terms of that data, your explanation
explains nothing (to me at least).

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"pejy69" wrote in message
...
Custom and key discounts for the Quarter. i presume the quarter being
april,
may & June
--
Enquirer


"Mike H" wrote:

Hi,

From the table below what answer do you expect to get?

Mike

"pejy69" wrote:

Below is the table i'm working with
However i've look at the previous link fro countif function's and wasnt
sure
how i could implememnt that for wat i need.

10% Custom $50,023.00 $50,023.00 $50,023.00
14% Key $110,353.00 $112,000.00 $112,300.00
5% Custom $48,201.00 $110,353.00 $95,820.00
14% Key $112,000.00 $23,340.00 $72,000.00

What i have to do is: use a countif function to count all discounts
(being %
column). note the discounts have to be for the quarter. not yearly.....
Thankyou for any help

--
Enquirer