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

He use 50%,50%,10% in the example Mike,so your formula doesn't look like the
solution, but like you I still have no idea what the requirement is.

--
---
HTH

Bob


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



"Mike H" wrote in message
...
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

I'm sure your right but I was rather hoping it would illicit a response along
the lines of " No that's wrong the answer should be......"

Looks like no points for this homework assignment:)

"Bob Phillips" wrote:

He use 50%,50%,10% in the example Mike,so your formula doesn't look like the
solution, but like you I still have no idea what the requirement is.

--
---
HTH

Bob


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



"Mike H" wrote in message
...
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

Its assignment based question so i only have the information in front of me
that i can give you....... They have stated it has to be a COUNTIF... we are
required to use the COUNTIF to ascertain the monthly discounts....sorry i
cant give you more but it's all the info i have
--
Enquirer


"Mike H" wrote:

I'm sure your right but I was rather hoping it would illicit a response along
the lines of " No that's wrong the answer should be......"

Looks like no points for this homework assignment:)

"Bob Phillips" wrote:

He use 50%,50%,10% in the example Mike,so your formula doesn't look like the
solution, but like you I still have no idea what the requirement is.

--
---
HTH

Bob


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



"Mike H" wrote in message
...
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